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-09919: Unable to set label of dedicated server

1 Answers  


ORA-37031: (XSMLTMAINT02) You cannot MOVE, DELETE, or add SESSION values of dimension workspace object in MULTI mode.

1 Answers  


ORA-19665: size string in file header does not match actual file size of string

1 Answers  


ORA-37115: New OLAP API history is not allowed

1 Answers  


TNS-00521: Missing keyword

1 Answers  






ORA-02192: PCTINCREASE not allowed for rollback segment storage clauses

1 Answers  


ORA-01956: invalid command when OS_ROLES are being used

1 Answers  


PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition

1 Answers  


TNS-04085: Password not changed since last save.

1 Answers  


ORA-19730: can not convert offline plugged-in datafile string

1 Answers  


DRG-12017: A redirection may change the behavior of this method - proceed anyway?

1 Answers  


TNS-00312: Connection Manager: Failed to get version information

1 Answers  


Categories