Re: Transparent Gateway for Sybase

From: Q <quintonm_at_bellsouth.net>
Date: 1998/06/12
Message-ID: <35816CC0.C53B8FD9@bellsouth.net>

Yes, I ran the script to create the procedures. It created them in the "sybsystemprocs" database. The procedure that I am trying to run is in the "development" database on the same server. I checked the permissions and all of the procedures it created are executable by public. Here is a little more information on what is going on.

the command issues in sql*worksheet on the Oracle database

execute "p_dts_update"@sgtymdev(52,'06/09/1998','N',2);

the result

"p_dts_update"@sgtymdev(52,'06/09/1998','N',2); *

ORA-06550: line 2, column 2:
PLS-00201: identifier 'p_dts_update_at_SGTYMDEV' must be declared
ORA-06550: line 2, column 2:

PL/SQL: Statement ignored

proof that the procedure name is correct

SQLWKS> select * from all_objects_at_sgtymdev
     2> where object_name = 'p_dts_update'
     3> and object_type = 'PROCEDURE'
     4>
OWNER                          OBJECT_NAME
OBJECT_ID
OBJECT_TYPE             CREATED              LAST_DDL_TIME

TIMESTAMP
STATU

------------------------------ ------------------------------
---------- --
--------------------- -------------------- --------------------

dbo                            p_dts_update
341628310
PROCEDURE               27-MAY-98            27-MAY-98
                       VALID

sql trace from the gateway

Oracle Transparent Gateway for SYBASE SQL Server: Release 4.0.0.1.0 -
Productio
n on Fri Jun 12 12:44:41 1998

Using ODBC driver version 02.00.1200 for SQL Server 11.00.0202 SQL Server/11.0.2
.2/P/HP9000-800/HP-UX 10.0/SWR 6879 Rollup/OPT/Sat Feb 15 01:09:09 PST user=SMOKES proces-id=220:194 term=SN40269 time=fri jun 12 12:44:43 cursor=1

Outgoing Parse SELECT dummysybs FROM dbo.dualsybs

user=SMOKES proces-id=220:194 term=SN40269 time=fri jun 12 12:44:44 cursor=1

Outgoing Parse SELECT dummysybs FROM dbo.dualsybs

user=SMOKES proces-id=220:194 term=SN40269 time=fri jun 12 12:45:37 cursor=1

odbctrace

SQLAllocEnv(phenv400779B0);
SQLAllocConnect(henv400779B0, phdbc400780E8); SQLConnect(hdbc400780E8, "DEVELOPMENT", -3, "SMOKES", -3, "********", -3);
SQLAllocStmt(hdbc400780E8, phstmt40087E00);

SQLGetInfo(hdbc400780E8, 72, rgbInfoValue, 4, pcbInfoValue);
SQLGetInfo(hdbc400780E8, 28, rgbInfoValue, 2, pcbInfoValue);
SQLGetInfo(hdbc400780E8, 7, rgbInfoValue, 16, pcbInfoValue);
SQLGetInfo(hdbc400780E8, 17, rgbInfoValue, 25, pcbInfoValue);
SQLGetInfo(hdbc400780E8, 18, rgbInfoValue, 100, pcbInfoValue);

SQLSetConnectOption(hdbc400780E8, 108, 00000002); SQLSetConnectOption(hdbc400780E8, 102, 00000000); SQLAllocStmt(hdbc400780E8, phstmt40088100); SQLProcedures(hstmt40088100, "(null)", 0, "SMOKES", 6, "p_dts_update", 12);
SQLGetInfo(hdbc400780E8, 20, rgbInfoValue, 2, pcbInfoValue); SQLBindCol(hstmt40088100, 8, -15, rgbValue, 2, pcbValue); SQLFetch(hstmt40088100);
SQLFreeStmt(hstmt40088100, 1);
SQLAllocStmt(hdbc400780E8, phstmt4008D9D0); SQLPrepare(hstmt4008D9D0, "SELECT * FROM SMOKES.p_dts_update", 33); SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
"odbctrace.out" 39 lines, 2655 characters SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLPrepare(hstmt4008D9D0, "SELECT * FROM DUAL", 18); SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLPrepare(hstmt4008D9D0, "SELECT dummysybs FROM dbo.dualsybs", 34); SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLAllocStmt(hdbc400780E8, phstmt40088100); SQLProcedures(hstmt40088100, "(null)", 0, "PUBLIC", 6, "p_dts_update", 12);
SQLGetInfo(hdbc400780E8, 20, rgbInfoValue, 2, pcbInfoValue); SQLBindCol(hstmt40088100, 8, -15, rgbValue, 2, pcbValue); SQLFetch(hstmt40088100);
SQLFreeStmt(hstmt40088100, 1);
SQLPrepare(hstmt4008D9D0, "SELECT * FROM p_dts_update", 26); SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLPrepare(hstmt4008D9D0, "SELECT * FROM p_dts_update", 26); SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLPrepare(hstmt4008D9D0, "SELECT dummysybs FROM dbo.dualsybs", 34); SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);
SQLError(henv00000000, hdbc00000000, hstmt4008D9D0, szSqlState, pfNativeError, s
zErrorMsg, 511, pcbErrorMsg);

Jayasaal Thuvassery wrote:

> Did you run the $ORACLE_HOME/tg4sybs/odbc/scripts/vsiproc4.sql script
> in Sybase ? This creates some objects in Sybase to support the
> procedural feature of the gaetway.
>
> Jay

Received on Fri Jun 12 1998 - 00:00:00 CDT