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?
You are on a dark path, good luck with that
I am sure some other rancher will give a hand.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads