Re: VB5 & Oracle & SPs & Owner Names

 Another approach might be to use Oracle's Objects for OLE. It will be part of the client installation
on Oracle 7.3 server cd's (Win95 or NT). Last I checked it was up to v 2.0.7. There is a help file and
a type lib (something like oip20.tlb). This Automation server communicates directly with the Oracle
OCI, bypassing ODBC and letting you call packaged procedures, get return values from procs,
use bind variables, etc.
It's also available from Oracle's web site http://www.oracle.com/download or FTP.
The release notes suggest that there should be a newer version by now, but I haven't seen anything.
As an alternative, you could code directly to the Oracle OCI. Seems to me that if it can be done with
C, Cobol, and Fortran, it should be possible in VB. If any hearty souls have ever attempted this, I'd
certainly be interested in hearing about it.

-Mike

gtr43839_at_glaxowellcome.com wrote in article <872025501.647_at_dejanews.com>...

>I've too have gotten SPs to work with input and output parms of different
>data types. Some weird behaviour (don't even use the .Type
>property..leave it be) but it worked. Until I tried to qualify a proc
>with an owner name!! Has anyone else been able to do this?
>
>In article ,
> kevin_at_winning.com wrote:
>>
>> You may want to try stored procedures. 3 months ago I tried RDO 2 with a
>> Oracle driver. I can not remember if it was the newest from Oracle at
>> the time. But their newest was not at ODBC level III anyway. I needed to
>> pass parameters both in and out of stored procedures. I couldn't make it
>> work so I tried the Microsoft driver that came with VB5. It has been
>> working fine for me.
>>
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Wed Aug 20 1997 - 00:00:00 CEST