This discussion is archived
0 Replies Latest reply: Aug 30, 2013 8:50 AM by Jodus RSS

calling database 10g procedure in forms 6i

Jodus Newbie
Currently Being Moderated


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;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points