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".

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)

 

[THoey]

Answer posted in Oracle 8 forum... Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?