Oracle/PLSQL: ORA-00910 Error

Error:

ORA-00910: specified length too long for its datatype

Cause:

You tried to create a VARCHAR2 or CHAR column, but you specified a length that exceeded Oracle's limits.

Action:

The options to resolve this Oracle error are:

Enter a maximum length for the VARCHAR2 or CHAR column that falls within Oracle's limits.

To find the maximum sizes for VARCHAR2 and CHAR datatypes, check out our Datatypes web page.