Database Error Messages

OCI-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.