ORA-00907: missing right parenthesis tips
Oracle Error Tips by Burleson Consulting
Oracle docs note this about ORA-00907:
missing right parenthesis
Cause: A left parenthesis has been entered
without a closing right parenthesis, or
extra information was contained in the
parentheses. All parentheses must be entered
Action: Correct the syntax and retry the
offers information regarding ORA-00907 in conjunction with
FULL/LEFT OUTER joins in association with Bug 4433936. This bug causing an ORA-00907
has been fixed in 10.2.0.3 and future versions of 11g, it can still be seen in
22.214.171.124, 126.96.36.199, 188.8.131.52, 10.1.0.5, and 10.2.0.2 in most generic platforms.
The symptoms of ORA-00907 and Bug 4433936 are simple syntax errors which
happen within parsing queries associated with FULL/LEFT OUTER joins. You
can work around ORA-00907 by trying Oracle join operators to rewrite queries, as
opposed to ANSI joins.
There is a great explanation for a common cause
of ORA-00907 on
Using sub index to raise a catsearch query, and
a query clause to get a range of date results, ORA-00907 is repeatedly thrown.
Here is my query:
WHERE CATSEARCH(FORENAMES, 'JOHN', 'DOB BETWEEN TO_DATE('01/01/1960','dd/mm/yyyy')
AND TO_DATE('01/01/1962','dd/mm/yyyy')')> 0;
To avoid ORA-00907, do I have to use some sort
of special query if I want to try a between clause in my catsearch query?
If you are using single quotes in phrases that
are surrounded by other single quotes, you have to add another single quote by
the inner single quotes to avoid ORA-00907. For example, you have to use
'___''___''___' instead of '___'___'___' in order for ORA-00907 to not be
thrown over syntax.
Here is an example of a date value with single
quotes, and the format string surrounded by double quotes:
Burleson is the American Team
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
and include the URL for the page.
Copyright © 1996 - 2012
All rights reserved.
is the registered trademark of Oracle Corporation.