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


PCC-00053: FOR variable string is invalid type at line
number in file string



PCC-00053: FOR variable string is invalid type at line number in file string..

Answer / guest

Cause: The count variable in a FOR clause has the wrong
datatype. The datatype must be NUMBER or LONG (or be
compatible with NUMBER or LONG).

Action: Check the declaration and check that the count
variable has a datatype of NUMBER or LONG (or a compatible
Oracle or host-language datatype).

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

AUD-00706: unsupported or corrupted input format

1 Answers  


RMAN-06223: starting up automatic instance string

1 Answers  


ORA-33078: (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.

1 Answers  


ORA-02705: osnpol: polling of communication channel failed

1 Answers  


ORA-07270: spalck: setitimer error, unable to set interval timer.

1 Answers  






TNS-00518: Incomplete read or write

1 Answers  


ORA-06567: invalid number of values specified

1 Answers  


ORA-31619: invalid dump file "string"

1 Answers  


LPX-00225: end-element tag "~1S" does not match start-element tag "~2S"

1 Answers  


ORA-39084: cannot detach job string for user string

1 Answers  


ORA-30026: Undo tablespace 'string' has unexpired undo with string(sec) left, Undo_Retention=string(sec)

1 Answers  


ORA-13218: max number of supported index tables reached for [string] index

1 Answers  






Categories