Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32031: illegal reference of a query name in WITH clause
- 2 Answers
- 12485 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 |
ORA-02026: missing LINK keyword
RMAN-05007: no channel allocated
ORA-12169: TNS:Net service name given as connect identifier is too long
PLS-00242: invalid external type specification for CONTEXT
ORA-27050: function called with invalid FIB/IOV structure
DRG-11104: Oracle Text error:
RMAN-06169: could not read file header for datafile string error reason string
ORA-17503: ksfdopn:string Failed to open file string
ORA-14010: this physical attribute may not be specified for an index partition
NZE-29157: Unable to build an absolute path to the library.
LPX-00402: invalid axisname in the XSL file
ORA-01135: file string accessed for DML/query is offline
Oracle Errors 
