Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32031: illegal reference of a query name in WITH clause
- 2 Answers
- 12490 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 |
EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
ORA-09746: smscre: shared memory attach address incorrect.
ORA-19686: SPFILE not restored due to string
ORA-24141: rule set string.string does not exist
ORA-32305: RepAPI materialized views with user-defined types are not supported
ORA-30042: Cannot offline the undo tablespace
RMAN-08093: specifying current controlfile for proxy backup
PCB-00232: Tables not allowed as input bind variables in SELECT statement
IMG-00840: image structure allocation failed
ORA-28155: user 'string' specified as a proxy is actually a role
PCC-02438: Arrays of collection objects are not allowed
QSM-01016: Query rewrite does not support, aggregate, string
Oracle Errors 
