PCC-00099: Length cannot be given for types ROWID, DATE, or
MLSLABEL



PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL..

Answer / guest

Cause: A length for the ROWID, DATE, or MLSLABEL external
datatype was specified in an EXEC SQL TYPE or EXEC SQL VAR
statement. This is unnecessary because those are fixed
length types.

Action: Remove the length specification from the EXEC SQL
TYPE or EXEC SQL VAR statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00871: Updates refused, name is a topology name: number

1 Answers  


ORA-15060: template "string" does not exist

1 Answers  


TNS-12688: Login failed: the SecurID server rejected the new pincode

1 Answers  


ORA-01878: specified field not found in datetime or interval

1 Answers  


PLS-01912: : instance must of be of type 'string'

1 Answers  






IMG-00861: assert failure, inconsistency in area merge operation

1 Answers  


QSM-01037: Query Rewrite failed to allocate the necessary query join graph

1 Answers  


ORA-29860: cannot truncate a table with domain indexes marked LOADING

1 Answers  


SQL*Loader-00465: %s directive expects number arguments, number found.

1 Answers  


ORA-07411: slgfn: full path name too big for supplied buffer.

1 Answers  


RMAN-00700: SCRIPT requires that TARGET be specified on the command line

1 Answers  


LSX-00243: invalid date "~S"

1 Answers  


Categories