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-01576: The instance string is not enabled
QSM-02051: subquery using the NOT EXISTS clause in mv
ORA-07455: estimated execution time (string secs), exceeds limit (string secs)
DRG-10701: preference string.string already exists
ORA-26706: cannot downgrade capture process
ORA-24308: illegal define position
RMAN-04009: WARNING from auxiliary database: string
ORA-30568: cannot drop log group - nonexistent log group
ORA-16050: destination exceeded specified quota size
ORA-39145: directory object parameter must be specified and non-null
TNS-12570: TNS:packet reader failure
LSX-00331: missing comma