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

TNS-00071: where <command> is one of following:

1 Answers  


RMAN-06133: recovery catalog may have obsolete data for datafile string

1 Answers  


ORA-23422: Oracle Server could not generate an unused job number

1 Answers  


PCB-00628: Buffer type is incompatible with LOB type

1 Answers  


ORA-01483: invalid length for DATE or NUMBER bind variable

1 Answers  






ORA-13146: could not find table substitution variable string

1 Answers  


RMAN-06114: changed controlfile copy available

1 Answers  


SQL*Loader-00963: Error clearing user-side Ctrl-C handler

1 Answers  


TNS-00078: * log_on - ask process_name to turn logging on

1 Answers  


NNO-00265: warning: cannot load data from checkpoint file

1 Answers  


IMG-00601: out of memory while copying image

1 Answers  


ORA-02043: must end current transaction before executing string

1 Answers  


Categories