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

DRG-11728: phrase does not have any broader terms of this type

1 Answers  


ORA-40206: invalid setting value for setting name string

1 Answers  


RMAN-06910: can not invoke parallel recovery for test recovery

1 Answers  


ORA-31662: metadata transform name can not be defaulted

1 Answers  


ORA-30344: number of child cols different from number of parent level cols

1 Answers  






UDI-00053: unrecognized client command 'string'

1 Answers  


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

1 Answers  


ORA-19207: scalar parameter string of XMLELEMENT cannot have an alias.

1 Answers  


ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context

1 Answers  


ORA-02253: constraint specification not allowed here

3 Answers  


ORA-12163: TNS:connect descriptor is too long

1 Answers  


ORA-37040: (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.

1 Answers  


Categories