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 |
EXP-00073: dump file size too small
NNO-00610: detected possible alias loop involving name "string"
ORA-14406: updated partition key is beyond highest legal partition key
RMAN-08011: including current controlfile in backupset
ORA-00402: database changes by release string cannot be used by release string
RMAN-10010: error while checking for RPC completion
ORA-31457: maximum length of description field exceeded
TNS-00084: * trace_off - ask process name to turn tracing off
ORA-13428: invalid modelCoordinateLocation
ORA-13627: Setting of parameter string is disallowed until the task is reset.
TNS-01411: Service "string" has number instance(s).
ORA-06720: TLI Driver: SID lookup failure