Resolving of parameters of stored procedures in runtime

[kvacik@email.cz]

Is there possibility to resolve parameters of stored procedures using a DOA function? I would prefer to call an OCI function than to create SQL statement to resolve it. I don't have sources of DOA component and I need to write an envelope of it to have it compatible with BDE.
Thanks for any idea how to make it.
Karel

 

[Marco Kalter]

You will have to query the all_arguments view for this. It's a single query, so it will be just as quick as any OCI call to describe a procedure.