Learn the motive and how to resolve the ORA-01727 error message in Oracle.
When you encounter an ORA-01727 error, the following error message will appear:
ORA-01727: numeric precision specifier is out of vary 1 to 38
You tried to specify a NUMERIC datatype, however you did no longer specify a precision value between 1 and 38.
The option(s) to resolve this Oracle error are:
Try modifying your NUMERIC datatype so that precision is between 1 and 38. If you do not specify a precision, Oracle assumes a precision of 22.
For example, if you tried to create the following table:
CREATE TABLE supplier ( supplier_id numeric(39) not null, supplier_name varchar2(50) not null );
You would receive the following error message:
You may want to correct this error by means of defining the supplier_id column as a NUMERIC column with precision between 1 and 38. In this example, we’ve got defined the precision as eight
CREATE TABLE supplier ( supplier_id numeric(8) not null, supplier_name varchar2(50) not null );
You can pass over the precision. Oracle will then assume a precision of 22.
CREATE TABLE supplier ( supplier_id numeric not null, supplier_name varchar2(50) not null );
In this example, NUMERIC is the same as NUMERIC(22).