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...


PCC-00056: FOR clause not allowed on SELECT statement at
line number in file string.



PCC-00056: FOR clause not allowed on SELECT statement at line number in file string...

Answer / guest

Cause: A FOR clause was used with a SELECT statement. This
is not allowed as data returned from the last loop in the
execution of the SELECT overwrites data returned in a
previous loop.

Action: Remove the FOR clause from the SELECT statement and
use a host- language construct to iteratively execute the
SELECT statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14623: Value string does not exist in subpartition string

1 Answers  


LPX-00005: ~1s buffer overflow, maximum size is ~2u bytes

1 Answers  


ORA-09200: sfccf: error creating file

1 Answers  


ORA-01487: packed decimal number too large for supplied buffer

1 Answers  


NNL-00567: reorder_ns [<server_address>] : Generate the enhanced discovery file

1 Answers  


ORA-36960: (XSFCAST27) The value of the string expression must be an odd number. You specified number.

1 Answers  


ORA-00295: datafile/tempfile number string is invalid, must be between 1 and string

1 Answers  


ORA-32763: Turn off N-Pass Temp LOB cleanup

1 Answers  


ORA-19597: file string blocksize string does not match set blocksize of string

1 Answers  


ORA-16126: loading table or sequence string

1 Answers  


TNS-02506: Authentication: no type string

1 Answers  


ORA-22286: insufficient privileges on file or directory to perform string operation

1 Answers  


Categories