ORA-32031: illegal reference of a query name in WITH clause
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 |
ORA-27076: unable to set limit for open files
RMAN-06121: uncataloged controlfile copy
DRG-50914: invalid last document number string
IMG-00872: unsupported image model
ORA-37132: (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.
IMG-00825: merged area queue pop failed
ORA-30688: maximum program calling depth exceeded
DRG-50852: failed to turn SQL trace on
NNL-00830: Delete requests received: number
ORA-25231: cannot dequeue because CONSUMER_NAME not specified
NNO-00802: Error: OCI_NEED_DATA
ORA-16732: Error executing dbms_logstdby.skip procedure