1 2 Previous Next 15 Replies Latest reply on Dec 9, 2012 8:28 PM by chongbing

    how to use calling stored procedures in oracle from FileMaker?

    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

        1 2 Previous Next