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

ORA-14048: a partition maintenance operation may not be combined with other operations

1 Answers  


ORA-39109: Unprivileged users may not operate upon other users' schemas

1 Answers  


ORA-24413: Invalid number of sessions specified

1 Answers  


PLS-00359: assignment target in 'string' must have components

1 Answers  


TNS-12659: Error received from other process

1 Answers  






NNO-00117: line string: missing data type, data ignored

1 Answers  


CLSR-00501: Error number encountered when connecting to EVM daemon

1 Answers  


ORA-30161: A system error occurred during the OCIFile function call

1 Answers  


LSX-00250: invalid normalizedString "~S"

1 Answers  


SQL*Loader-00262: PIECED keyword (on column string) allowed only when path is direct

1 Answers  


ORA-07579: spini: $DCLEXH failure

1 Answers  


IMG-00553: invalid rotate value

1 Answers  


Categories