SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Execute immediate for stored procedure with out parameter

829960Mar 5 2012 — edited Mar 6 2012

Hi,
I have problem with dynamically executing the statement hope anyone can help me.

I have a table which stores the procedure names. and procedure parameter values are stored on another column with parameter values coming from java side.
I have to create a procedure that dynamically executes the procedure on table1 with the values from table 2.
Now I'm getting real trouble to execute immediate this proc with parameters. I tried the DBMS_SQL package as well.
Problem is you need to mention the OUT mode specifically for the out parameter. Can anybody plz help me with this issue??

TABLE1_

PROCESS_ID PROC_NAME
1 proc1(p1 IN number, p2 IN varchar2, p3 OUT varchar2)
2 proc2(p1 IN number, p2 out varchar2, p3 OUT varchar2)

TABLE2_

PROCESS_ID PROC_PARMS
1 100, 'test', :return
2 200, :return1, :return2

Thank You

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2012

Added on Mar 5 2012

6 comments

2,260 views