ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle error ORA-604 when opening a connection

932098Apr 20 2012 — edited Apr 23 2012

I am facing an issue with my WCF service which is using ODP.NET version 4.112.2.0(x64) and Oracle 11g.

The service runs without any problems on the test servers but on production server (Windows 2008 R2) when an attempt is made to call any service method it fails with the following Oracle error code Ora-604. the message is

ORA-604: error occurred at recursive SQL level %s

The exception is thrown when a call to meethod Open is made to open a connection.
There is no inner exception. So far I have tried checking the connection string, the user permissions and setting the TNS_ADMIN environment variable but nothing has worked.

Another thing to mention is that another WCF service which uses some of the same stored procedure I am using is working fine on the same server.

Has anyone seen this before?

Thanks,
A

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2012

Added on Apr 20 2012

#odp-net

1 comment

5,635 views