bkapkap
Apr 6th, 2000, 09:39 PM
OK ...
I donīt understand your Q, very well.
The solution, is (in my way), use ADO and ADO Command Objects. Using this objects you probably can "capture" the output in a SP.
You must remember, in ORACLE, SP don't returns a rowset of data, (in SQL server, i.e., this is a posibility). the final results is an array, it is build from a cursor. And for each row in the result you should declare a cursor variable.
I have some examples if you want to check them.
for more info, http://www.msdn.com. Search fro : "Trips in ORACLE"
Good Luck.
I donīt understand your Q, very well.
The solution, is (in my way), use ADO and ADO Command Objects. Using this objects you probably can "capture" the output in a SP.
You must remember, in ORACLE, SP don't returns a rowset of data, (in SQL server, i.e., this is a posibility). the final results is an array, it is build from a cursor. And for each row in the result you should declare a cursor variable.
I have some examples if you want to check them.
for more info, http://www.msdn.com. Search fro : "Trips in ORACLE"
Good Luck.