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

ORA-07442: function address must be in the range string to string

1 Answers  


ORA-12854: Parallel query is not supported on temporary LOBs

1 Answers  


ORA-02238: filename lists have different numbers of files

1 Answers  


ORA-30157: An invalid argument was given to operating system call

1 Answers  


CLSS-00102: initialization failure: [string] [string] [string] [string] [string] [string]

1 Answers  






ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS

1 Answers  


ORA-13361: not enough sub-elements within a compound ETYPE

1 Answers  


ORA-14409: inserted partition key is outside specified subpartition

1 Answers  


ORA-02263: need to specify the datatype for this column

1 Answers  


RMAN-06549: connected to auxiliary database: string (not mounted)

1 Answers  


ORA-24853: failed to connect thread to shared subsystem

1 Answers  


ORA-39006: internal error

1 Answers  






Categories