Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle8.1.5, ODBC+calling stored procedures

Oracle8.1.5, ODBC+calling stored procedures

From: Heiko Hüter <Heiko.Hueter_at_gmx.de>
Date: Wed, 17 Nov 1999 18:02:09 +0100
Message-ID: <80un4s$156aa$1@fu-berlin.de>


Hi all,

I'm trying to invoke PL-SQL procedures via ODBC (under NT4.0). Calling a procedure in the current database works (call TEST(1)). Calling a procedure in a database via a link (call TEST_at_DB452210(1)) does produce the following error :

[Oracle][ODBC][Ora]ORA-04052: error occurred when looking up remote object
SYSADM.TEST_at_DB452210 ORA-00604: error occurred at recursive SQL level 1 ORA-02041: client database did not begin a transaction

I'm using the ODBC driver with version 8.01.54 which seems to be the newest available at technet. Accessing an remote table (Select * From TAB_TEST_at_DB452210)
does produce an similar error :

[Oracle][ODBC][Ora]ORA-02041: client database did not begin a transaction

Did anyone experienced similar problems. Any workarounds or patches known ?

Any help greatly appreciated,

Bye,

Heiko. Received on Wed Nov 17 1999 - 11:02:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US