PCC-00114: Length spec required in EXEC SQL VAR statements
for VARxxx types



PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types..

Answer / guest

Cause: In an EXEC SQL VAR statement, a VARCHAR or VARRAW
external datatype was specified without a length. Unlike
other types, the maximum length of the data field must be
specified for VARCHAR and VARRAW.

Action: Add a length specification to the 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

LFI-00143: Unable to delete non-existent file string.

1 Answers  


ORA-01863: the year is not supported for the current calendar

1 Answers  


DRG-11442: valid gist numParagraphs values are string

1 Answers  


ORA-31666: Master process string had an unhandled exception.

1 Answers  


ORA-09787: sllfop: unrecognizable processing option, incorrect format.

1 Answers  






ORA-02380: profile string does not exist

1 Answers  


NCR-04017: NCRR: Unable to find the interface instance handle

1 Answers  


DRG-11214: execution of procedure filter stored procedure has failed

1 Answers  


ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT

1 Answers  


RMAN-00701: SCRIPT requires that CATALOG be specified on the command line

1 Answers  


ORA-02333: cannot create constraints on attributes of this column

1 Answers  


ORA-24094: invalid transformation, target type does not match that of the queue

1 Answers  


Categories