PCC-00114: Length spec required in EXEC SQL VAR statements
for VARxxx types
- 1 Answers
- 1642 Views
- I also Faced
- E-Mail Answers
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 |
LPX-00413: loss of precision due to excessively large numerical constant
ORA-06263: NETNTT: out of memory in pi_connect
RMAN-06525: RMAN retention policy is set to none
ORA-29846: cannot create a local domain index on a string partitioned table
ORA-06800: TLI Driver: SQL*Net SPX client went away during reconnect
ORA-03240: User's temporary tablespace same as tablespace being migrated
ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
ORA-40106: positive target value not specified for computing Lift
TNS-01412: Handler(s):
ORA-15196: invalid ASM block header [string:string] [string] [string] [string] [string != string]
RMAN-20031: resync not started
RMAN-04003: ociinit failed
Oracle Errors 
