ORA-7445 and cursor_sharing=force

From: Syd H. Shah Khan <habeeb_shahkhan_at_hotmail.com>
Date: 17 Jun 2002 01:03:33 -0700
Message-ID: <ae0b2c43.0206170003.d957c11@posting.google.com>

I think I have narrowed the problem down to a certain extent. When the SQL in the library cache is invalidated, then when the same piece of code is rerun, it hits an ORA-7445 error.

As long as the SQL is not invalidated I can run the code several times. But once it is invalidated (due to DDL on dependent object), Oracle cannot reprase the same statement and hits and ORA-7445 error.

The parameter cursor_sharing is set for force. And the server is running MTS. The only workaround to the problem is to set cursor_sharing = exact. I want to make use of cursor_sharing = force since the application does not make use of bind variables and therefore cursors are not being reused/shared. Thank you in advance. Received on Mon Jun 17 2002 - 03:03:33 CDT