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-01576: The instance string is not enabled

1 Answers  


QSM-02051: subquery using the NOT EXISTS clause in mv

1 Answers  


ORA-07455: estimated execution time (string secs), exceeds limit (string secs)

1 Answers  


DRG-10701: preference string.string already exists

1 Answers  


ORA-26706: cannot downgrade capture process

1 Answers  


ORA-24308: illegal define position

1 Answers  


RMAN-04009: WARNING from auxiliary database: string

1 Answers  


ORA-30568: cannot drop log group - nonexistent log group

1 Answers  


ORA-16050: destination exceeded specified quota size

1 Answers  


ORA-39145: directory object parameter must be specified and non-null

1 Answers  


TNS-12570: TNS:packet reader failure

1 Answers  


LSX-00331: missing comma

1 Answers  


Categories