Procedure Parameters

bir

Member
I need to create a function that accepts a storedproc name and a TStringList of parameters. So first thing I must do is query the DB and get the list of parameters and types then convert each string to the appropriate type. Then I will use ExecuteArray to make bulk calls to the storedproc. I know that the parameter information is available in sys.all_arguments, but are there any helper functions that will automatically create and init the parameters of a OracleQuery with just a StoredProc name?

------------------
 
No, there is no functionality for this in Direct Oracle Access.

------------------
Marco Kalter
Allround Automations
 
Back
Top