Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-32031: illegal reference of a query name in WITH clause

Answers were Sorted based on User's Feedback



ORA-32031: illegal reference of a query name in WITH clause..

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

ORA-32031: illegal reference of a query name in WITH clause..

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

Post New Answer

More Oracle Errors Interview Questions

PLS-01710: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1

1 Answers  


ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine

1 Answers  


ORA-27015: skgfcls: failed to close the file

1 Answers  


NNL-00903: SERVER FAILURE responses sent: number

1 Answers  


LSX-00235: invalid URI "~S"

1 Answers  






ORA-07209: sfofi: file size limit was exceeded.

1 Answers  


ORA-07632: smsrcx: $DELTVA failure

1 Answers  


ORA-22896: cannot have both scope and referential constraint on REF column "string"

1 Answers  


RMAN-08505: output filename=string

1 Answers  


PLS-01469: ANSI standard does not permit records

1 Answers  


NNL-01075: Contact string

1 Answers  


QSM-01039: selection present on right hand side of an outer join

1 Answers  






Categories