Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: input/output parameter: howto get the output from VB6
Jesse, thanks again
it does not work :(
one thing I forgot to say is that ADO installed on my PC is 2.6, but the ORAOLEDB is "Oracle Provider for OLE DB 8.1.7.0.0". The DB is 9.2.0.4
Then, you are right: the "-1" tells the SP that I want a new report to be saved, so that it not only returns me the rows of the report, but also its "ID", which is also passed back in the same parameter.
By the way, we found a quite easy work around: we added an extra OUT
parameter to the SP where the SP passes this "ID" back to the COM
object, and this works perfectly.
But I would *really* understand why I cannot make the same with an
in/out parameter.
Thanks for your patience and help
Regards
Carlo
Received on Thu May 19 2005 - 10:47:22 CDT