Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00937 when CURSOR_SHARING=FORCE
You can several things
- search for this error on Metalink. As I have the feeling it is a bug
you'll need
- to upgrade to 9.2.0.6.0 at least
Alternatively you could trace the affected session and search for
err=937
in your trace file, and watch the *exact* statement resulting in this
error.
You could also do the following (in sql*plus)
variable x varchar2(...)
begin
:x := '<your value>';
end;
/
Select Count(*) as Total From IINEHABIT Where
IgCargasM=:x
/
To verify whether this behavior occurs with a *true* bind variable
(sql*plus doesn't use bind variables by default, so it MUST use the
same mechanism as in the affected program)
Hth
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Dec 21 2005 - 03:02:34 CST