Page 1 of 1

SYS_CONTEXT AND Oracle 7.3 SERVERS

Posted: Fri 11 Mar 2005 18:01
by Marcio
I'm trying to connect to a 7.3.45 Server and I'm getting the error

"ORA06550 - line 1, column 19
PLS- 00201 - Identifier SYS_CONTEXT must be declared
PL/SQL Statement ignored"

I've set the debug switch on it seems that right before connection ODAC is issuing a

SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')

which is not supported in a 7.3 Oracle Server. I've tried to force OCI7, tried NET and other options, but it keeps giving the error.

I'm using Delphi 7.1, ODAC 5.50.016, Oracle Client 9.0.111 and Server 7.3.4.5.

Can anybody help ??

Posted: Mon 14 Mar 2005 09:19
by Alex
We reproduced your problem and fixed it. This fix will be included in the next ODAC build.