Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32031: illegal reference of a query name in WITH clause
- 2 Answers
- 12589 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 |
PCB-00558: Invalid external datatype specified in EXEC SQL VAR statement
PCC-02044: CMD-LINE: Illegal or out of range value for option:
DRG-50301: server error reading request queue
ORA-09330: Session terminated internally by Oracle or by an Oracle DBA
ORA-13112: cannot delete topo_geometry layer [string] from topology
ORA-26064: Invalid SCN specified - Wrap: string Base: string.
PCC-02437: Expecting an expression having binary integral type
RMAN-06532: redundancy count must be greater than zero
ORA-00160: global transaction length string is greater than maximum (string)
ORA-02166: ARCHIVELOG and NOARCHIVELOG specified
KUP-04005: file operation successful
ORA-16537: child count exceeded
Oracle Errors 
