Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: input/output parameter: howto get the output from VB6

Re: input/output parameter: howto get the output from VB6

From: carl <carlogol_at_virgilio.it>
Date: 19 May 2005 08:47:22 -0700
Message-ID: <1116517642.739643.119150@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US