Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-29260: network error: string

1 Answers  


ORA-06137: NETTCP: error during connection handshake

1 Answers  


ORA-36612: (XSLMS01) An application attempted to retrieve a non-existent user message. (Product: value, Facility: value, Message Number: value)

1 Answers  


ORA-23505: Object "string"."string" is missing.

1 Answers  


TNS-12516: TNS:listener could not find available handler with matching protocol stack

1 Answers  






ORA-30733: cannot specify rowid constraint on scoped ref column

1 Answers  


ORA-13608: The task or object name string is invalid.

1 Answers  


ORA-12030: cannot create a fast refresh materialized view

1 Answers  


ORA-16583: bad Data Guard Connection Process DRCX state

1 Answers  


PLS-00148: Only 1 pragma of this type is allowed per subprogram

1 Answers  


ORA-23389: obsolete procedure; drop objects and recreate using new master

1 Answers  


ORA-32839: property string is reserved, names with MGWPROP$_ prefix are not valid

1 Answers  






Categories