Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32031: illegal reference of a query name in WITH clause
- 2 Answers
- 12453 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-50929: parser internal on line string on column string
ORA-29893: indextypes without column data do not need the given data type
SQL*Loader-00419: input datatype for column string is not supported when loading varrays
NCR-04009: NCRR: Object exists
DRG-10001: can not access result table string
PLS-00210: an OTHERS clause is required in this CASE statement
ORA-23302: application raised communication failure during deferred RPC
PLS-01466: Null strings are not allowed
LPX-00207: expected "[" at the start of conditional section
DRG-12212: error while dropping section string
ORA-26663: error queue for apply process string must be empty
IMP-00062: Warning: The identifier on the dump file for object type "string"."string" is invalid
Oracle Errors 
