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


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

LPX-00413: loss of precision due to excessively large numerical constant

1 Answers  


ORA-06263: NETNTT: out of memory in pi_connect

1 Answers  


RMAN-06525: RMAN retention policy is set to none

1 Answers  


ORA-29846: cannot create a local domain index on a string partitioned table

1 Answers  


ORA-06800: TLI Driver: SQL*Net SPX client went away during reconnect

1 Answers  






ORA-03240: User's temporary tablespace same as tablespace being migrated

1 Answers  


ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.

1 Answers  


ORA-40106: positive target value not specified for computing Lift

1 Answers  


TNS-01412: Handler(s):

1 Answers  


ORA-15196: invalid ASM block header [string:string] [string] [string] [string] [string != string]

1 Answers  


RMAN-20031: resync not started

1 Answers  


RMAN-04003: ociinit failed

1 Answers  






Categories