Re: VB6 to Oracle 8.0.4.0 stored procedure

DirK:

I agree on the suggestion to use OO4O, but one thing that you might note if its your first time to use OO4O, which I found out the hard way, is to make sure to find the include list that defines all the oracle VB constants and paste it into your declarations section. When you include the Oracle objects library as a dependency, Intellisense will list the objects and methods, but will not pick up the constants. Unfortunately, the constants are still not defined, and all the OO4O stuff doesnt work until you finally realize that you are passing all zeros into the functions. Just a heads up, since none of the documentation mentions that you should include this list!

Dave

Christopher M. Day wrote in message
<372793AE.960BF168_at_rdbms.freeserve.co.uk>...
>Dirk,
>
>I take it you haven't tried using OO4O (Oracle Objects for OLE), it gets
>around all the limitations present by ADO and RDO, sorry features.
>
>Chris
>
>Dirk Kumashiro wrote:
>>
>> Hello,
>> Has anyone else run into an overflow problem when calling a stored
>> procedure with over 10 parameters within VB6? Any ideas on a solution
to
>> this? The stored procedure works from sql plus, but not in VB.
Thanks
>>
>> Dirk
Received on Wed Apr 28 1999 - 20:06:29 CDT