Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-01727

numeric precision specifier is out of range (1 to 38)

Cause

The precision specified for a number column in a CREATE or ALTER TABLE or CREATE CLUSTER statement must be a digit between 1 and 38. If no precision was specified, a default precision of 22 digits was used.


Action

Specify numeric precision between 1 and 38 and retry the statement.