Oracle/PLSQL: ORA-00910
Learn the cause and how to resolve the ORA-00910 error message in Oracle.
Description
When you encounter an ORA-00910 error, the following error message will appear:
- 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.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Enter a maximum length for the VARCHAR2 or CHAR column that falls within Oracle’s limits.
