SYS_CONTEXT AND Oracle 7.3 SERVERS

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Marcio

SYS_CONTEXT AND Oracle 7.3 SERVERS

Post by Marcio » Fri 11 Mar 2005 18:01

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 ??

Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Mon 14 Mar 2005 09:19

We reproduced your problem and fixed it. This fix will be included in the next ODAC build.

Post Reply