Re: ORA-00937 when CURSOR_SHARING=FORCE

One item that deserves mentioning, is that hinting the problematic statement with

 /*+ cursor_sharing_exact */

should take care of this issue, without requiring that cursor_sharing=exact be set session-wide.

I've seen this type of issue before on 10.1.0.3 on win32. It was fixed in 10.1.0.4.

IMHO, base releases of the product really aren't for production use - they're for testing.
The 9i R2 release wasn't "ready" until 9.2.0.4.

If you have metalink access check the readme.html for the 9.2.0.7 patchset and you'll likely see fixes listed for this class of error.

hth.
-bdbafh Received on Wed Dec 21 2005 - 07:36:54 CST