Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32031: illegal reference of a query name in WITH clause
- 2 Answers
- 12352 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-28514: heterogeneous database link initialization could not convert system date
ORA-26010: Column string in table string is NOT NULL and is not being loaded
ORA-19609: %s is from different backup set: stamp string count string
ORA-31513: unsupported column type specified in change table
TNS-01099: %s * string * string * string * number
ORA-13371: invalid position of measure dimension
ORA-13027: unable to read dimension definition from string
AMD-00146: Custom Measure "string" already exists in Workspace "string"
ORA-31097: Hierarchical Index not empty
DRG-11733: more than one translation for the term in the specified language
ORA-25216: invalid recipient, either NAME or ADDRESS must be specified
NNO-00152: warning: hint count number exceeds maximum of number, first number will be loaded
Oracle Errors 
