Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-27076: unable to set limit for open files

1 Answers  


RMAN-06121: uncataloged controlfile copy

1 Answers  


DRG-50914: invalid last document number string

1 Answers  


IMG-00872: unsupported image model

1 Answers  


ORA-37132: (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.

1 Answers  


IMG-00825: merged area queue pop failed

1 Answers  


ORA-30688: maximum program calling depth exceeded

1 Answers  


DRG-50852: failed to turn SQL trace on

1 Answers  


NNL-00830: Delete requests received: number

1 Answers  


ORA-25231: cannot dequeue because CONSUMER_NAME not specified

1 Answers  


NNO-00802: Error: OCI_NEED_DATA

1 Answers  


ORA-16732: Error executing dbms_logstdby.skip procedure

1 Answers  


Categories