ORA-00910: specified length too long for its datatype



ORA-00910: specified length too long for its datatype..

Answer / guest

Cause: for datatypes CHAR and RAW, the length specified was
> 2000; otherwise, the length specified was > 4000.

Action: use a shorter length or switch to a datatype
permitting a longer length such as a VARCHAR2, LONG CHAR, or
LONG RAW

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13384: error in network schema: string

1 Answers  


TNS-00027: INTCTL: Could not resolve Navigator's name/address

1 Answers  


ORA-25526: bad format of _DB_MTTR_SIM_TARGET: string

1 Answers  


PLS-01469: ANSI standard does not permit records

1 Answers  


ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off

1 Answers  






SQL*Loader-00303: Non-hex character encountered where hex char expected

1 Answers  


ORA-06317: IPA: Local maximum number of users exceeded

1 Answers  


RMAN-08012: including controlfile copy in backup set

1 Answers  


TNS-02503: Parameter retrieval failed

1 Answers  


QSM-01046: complex join back on correlated columns not allowed (string)

1 Answers  


EXP-00070: attempt to free unallocated memory

1 Answers  


ORA-12159: TNS:trace file not writeable

1 Answers  


Categories