Database Error Messages

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

ORA-01728

numeric scale specifier is out of range (-84 to 127)

Cause

The scale specified for a numeric field in a CREATE or ALTER TABLE or CREATE CLUSTER statement was not in the valid range. It should be between -84 and 127.


Action

Specify a numeric scale between -84 and 127. If a number is not specified, the default scale of the column is 0 decimal places.