I am trying to write a function which takes stored procedure's name and it's arguments as argument and execute it.
Now I want that, the function should be able to know wat data is being output from the sp, so I can set datatype of output variable of sp.
How to do this ?
There are no failures, only experiences
posted 5 years ago
I guess you have to look up for your procedure in database metadata and learn about it in details. But there are many things to be considered like how many and what types of arguments does the procedure have? How to handle CLOB, BLOB and raw types? What about UDTs?