Calling stored procedure from TOracleDataSet

[dEnvEr]

Hi everybody,

I am using a function inside my TOracleDataSet SQL which has one input and one output variable. I am wondering if it is possible to use stored procedure instead of a function? here is my SQL with function

Select rec_id, fname, lname, myfunction(id) 'Category'
from customer_t

I tried couple of variations with stored procedure but couldn't make it work. Stored procedure has one input and one output variables as well.

Thanks for your help.

 

[Marco Kalter]

Do you mean that you want to call a stored procedure with an output parameter from within a SQL select statement? This is not directly possible. Indirectly you could use a function that calls the procedure and returns the output parameter.

------------------
Marco Kalter
Allround Automations