Oracle Transparent Gateway for MSSQL

From: Chris Bassett <chrisb_at_halcyon.com.NOSPAM>
Date: 24 Apr 1998 23:35:22 GMT
Message-ID: <01bd6fda$a9a294c0$af7e10ac@bassett>

We're using Oracle Transparent Gateway between Oracle 7.3 and MS SQL 6.5
(Service Pack 3). We can query the MS SQL tables just fine. Execution of
MS SQL stored procedures is a different matter entirely.

The MS SQL Trace utility indicates that the sp_stored_procedures and sp_sproc_columns catalog stored procedures get called when calling a stored procedure through the gateway. The stored procedure call errors out with an "Oversized data trying to be inserted into table" when attempting to insert the output parameter of the MS SQL stored procedure call to an Oracle table.

I've tweaked the ODBC DSN that the gateway uses to NOT generate a prepared statement, but still having the same result. Should I be using the pass through option of the gateway??

TIA Chris Bassett
(please remove NOSPAM from the end of the email address to reply)
Received on Fri Apr 24 1998 - 18:35:22 CDT