0 Replies Latest reply: Aug 30, 2013 10:50 AM by Jodus RSS

    calling database 10g procedure in forms 6i

    Jodus


      Hi,

       

      Here the structure of the code in procedure and forms, the problem is the out parameter not returning any values to the form. but it returns when executing in database.

      versions database 10g, and forms 6i, Form user  has the privilages to execute the procedure, do the forms user need any other privilage?

       

      Thanks for you help

       

       

      IN DATABASE>>>

      CREATE OR REPLACE PROCEDURE USER2.PROC1
                ( IN_ID IN TABLE1.ID%TYPE,
                  IN_NO IN TABLE2.NO%TYPE,
                  OUT_REC OUT TABLE3%ROWTYPE) IS


      Begin

      Declare

      V_REC        TABLE3%ROWTYPE;

      CURSOR GET_DATA_CUR(IN_ID IN TABLE1.ID%TYPE) IS
             SELECT ID
             FROM TABLE4,TABLE5
             WHERE TABLE5.ID = IN_ID
             AND TABLE4.CODE = TABLE5.CODE;

      Begin

       

         OPEN GET_DATA_CUR(IN_ID);
              FETCH  GET_DATA_CUR INTO V_REC.ID;
              CLOSE GET_DATA_CUR;

      OUT_REC :=V_REC;

      End;

      End;


      IN FORM>>>>

      declare

         VALUES_REC           TABLE3%ROWTYPE;

      Begin

            USER2.GET_VALUES(:ID,:NO,VALUES_REC);
           
            message(VALUES_REC.ID); message(VALUES_REC.ID);
        

      End;