| ORA-00907 : Formatting Error [message #629887] |
Wed, 17 December 2014 00:58  |
 |
abhayman
Messages: 37
Registered: August 2011
Location: CA
|
Member |
|
|
Hi,
I am getting error while running a query although I don't see any formatting issue.
SELECT cth.transaction_id,
cth.so_number
FROM ABC cth
WHERE cth.so_number IN
( SELECT TO_NUMBER (TRIM (REGEXP_SUBSTR (TRIM (12104010),
'[^,]+',
1,
LEVEL)))
Freq_Value
FROM DUAL
CONNECT BY TRIM (REGEXP_SUBSTR (TRIM (51205501),
'[^,]+',
1,
LEVEL))
IS NOT NULL
ORDER BY LEVEL)
Although the inner condition works fine . The issue is happening only when I add IN condition
|
|
|
|
| Re: ORA-00907 : Formatting Error [message #629889 is a reply to message #629887] |
Wed, 17 December 2014 01:07  |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Well ORA 00907 really seems to be "missing right parenthesis", not "formatting error", so the tool you use might mix something up.
$oerr ORA 00907
00907, 00000, "missing right parenthesis"
// *Cause:
// *Action:
As for the "missing right parenthesis", you can't us an "order by" in an "in" clause.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
