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 |
TNS-00071: where <command> is one of following:
RMAN-06133: recovery catalog may have obsolete data for datafile string
ORA-23422: Oracle Server could not generate an unused job number
PCB-00628: Buffer type is incompatible with LOB type
ORA-01483: invalid length for DATE or NUMBER bind variable
ORA-13146: could not find table substitution variable string
RMAN-06114: changed controlfile copy available
SQL*Loader-00963: Error clearing user-side Ctrl-C handler
TNS-00078: * log_on - ask process_name to turn logging on
NNO-00265: warning: cannot load data from checkpoint file
IMG-00601: out of memory while copying image
ORA-02043: must end current transaction before executing string