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

Jesse

thanks for your quick answer, but i tried with 20 and 30 and it's still the same.
As for Oracle, it's 9.2.
Then this is the driver version - OraOLEDB.Oracle.1 - Version: 2.6 By the way, the connection string has the PLSQLRSET=1, since the stored procedure returns a ref cursor as an out parameter (that's why I wrote

      oRS = ...)

As for the Vb/SP, there is not much to say about. The vb method is quite straightforward: receives various parameter, open the connection, create the ado command, populates its parameters collection, and finally retrieves the recordset and the out parameters. The SP is basically executing a quite complex query on the db and returns the records in this recordset (as an OUT REF Cursor) then performs some calculations and returns some values back to the caller.

Thanks again
Carlo Received on Thu May 19 2005 - 09:17:39 CDT