I am trying to call an Oracle stored procedure from SqlServer.  I have tried
both the MS and Oracle OLE DB Providers.

I can select records from Oracle and I can insert records to Oracle.  The
stored proc call dies.

The interesting part in this is that I can write a VB script that calls the
stored procedure from the server that the SqlServer instance is running on
and it is able to execute the proc.  The VB script uses Oracle's OLE DB
Provider.

We are using SqlServer 2000 and Oracle 9.2.0.6

I am sure that there is something setup incorrectly with SqlServer.


Any ideas
RSL

Himm?
So i think u must use sp_OACreate, sp_OAMethod, sp_OADestroy methods in sql
server procedures or triggers.
First, make a dll for oracle actions. And call dll in sql server t-sql with
those method.

StoredProc Help...
Database Maintenance Plan Grief
Combine 3 Queries into One
stored procedure
open table
Commenets on Running Citrix on SQL Server? Anyone doing this?
Question on the evacuate of the datafile
Question on Hardware failover of the MS SQL Server 2000 DB
synonyms in SQL server 2000
Alert & Cache Hit Ratio