Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32031: illegal reference of a query name in WITH clause
- 2 Answers
- 12594 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-29872: parameters clause cannot be combined with the specified options
ORA-01019: unable to allocate memory in the user side
ORA-31673: worker process interrupt for normal exit by master process
DRG-11529: token exceeds maximum length
ORA-12515: TNS:listener could not find a handler for this presentation
ORA-02448: constraint does not exist
ORA-00336: log file size string blocks is less than minimum string blocks
LCD-00114: illegal boolean response [string]
ORA-32018: parameter cannot be modified in memory on another instance
PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types
PLS-01710: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1
ORA-29804: missing DATA keyword
Oracle Errors 
