chongbing

how to use calling stored procedures in oracle from FileMaker?

Discussion created by chongbing on Dec 3, 2012
Latest reply on Dec 9, 2012 by chongbing

Hello,

 

Anybody know how to use calling stored procedures in oracle from FileMaker?

 

 

For example, I have just a simple stored procedure in oracle ,and test table name is SP_TEST as below.

but how to call it in FileMaker? many thanks.

 

 

Package Body FM_TEST IS

 

 

PROCEDURE return_record ( type_z_set in out type_z) IS

 

BEGIN

open type_z_set for ' select col1,col2,col3,col4,col5,col6 from test1 ' ;

EXCEPTION WHEN others THEN

open type_z_set for ' select ''error'' from dual ' ;

END;

 

 

PROCEDURE get_sp_test ( pk_id in number,type_z_set in out type_z) IS

 

BEGIN

open type_z_set for ' select pk_id,text_test,number_test,date_test from sp_test ' ;

EXCEPTION WHEN others THEN

open type_z_set for ' select ''error'' from dual ' ;

END;

 

 

 

END; -- Package Body FM_TEST

Outcomes