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

QSM-01017: aggregate argument cannot be converted to canonical form

1 Answers  


ORA-31479: could not create LogMiner session

1 Answers  


RMAN-06150: auxiliary name for datafile number set to: string

1 Answers  


NZE-28845: No certificate

1 Answers  


LSX-00300: group must have name or ref but not both

1 Answers  


PCC-02393: SQL statement found inside an EXEC SQL DECLARE SECTION

1 Answers  


ORA-29915: cannot select FOR UPDATE from collection operand

1 Answers  


NZE-29100: Cannot create local key ID.

1 Answers  


ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.

1 Answers  


ORA-12842: Cursor invalidated during parallel execution

2 Answers   ACC,


PCC-00118: Use of host variable initialization not supported by ANSI SQL

1 Answers  


ORA-22833: Must cast a transient type to a persistent type

1 Answers  


Categories