Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32031: illegal reference of a query name in WITH clause
- 2 Answers
- 12354 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / slapper
Yeah, that was helpful. Whoever wrote this should be
slapped. If you're not going to be helpful, then don't
post. Some possible areas to explore are:
1. Are you running Oracle 11g
2. Do you have the anchor and recursive sections in the
right order? Anchor first, recursive later.
3. If you aren't trying to do recursion, simply avoid
using the With cursor name in the same Select block
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / guest
Cause: forward or recursive reference of a query name in
WITH clause is not allowed.
Action: Correct query statement, then retry.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 6 No |
DRG-12439: highlight table read failed
ORA-25295: Subscriber is not allowed to dequeue buffered messages
ORA-00450: background process 'string' did not start
ORA-27045: unable to close the file
NNL-00295: Controller's local trace level is currently number
NZE-29231: the cryptographic engine failed to initialize
KUP-04038: internal error: string
ORA-27457: argument string of job "string.string" has no value
TNS-12160: TNS:internal error: Bad error number
ORA-06801: TLI Driver: listen for SPX server reconnect failed
NNL-00230: Controller NOCONFIRM mode is currently string
NCR-04005: NCRR: Invalid procedure handle
Oracle Errors 
