DYNAMIC STORED PROCEDURE! (HELP NEEDED!)

[naarora]

Hello All,

I want to write a program which takes procedure name and input, output parameters at run time and executes the procedure.

In other words the stored procedure name, input parameters and output parameters are being specified only at the run-time and are not known at the compile time.

I am using Pro"C" and oracle 8i.

Can oracle dynamic sql 4 help me?

or can oracle native sql can be of some help?


Thanks for any help.

Naveen Arora (naarora@hss.hns.com)

 

[Guest_imported]

Try out this:
create or replace
procedure dy_proc(proc_name varchar2, param1 varchar2)
is
begin

execute immediate
'begin
proc_name'||'p);
end;'
using param1;
end;