All Oracle Error CodesOracle DBA Forum


Scale is not supported for host variable "string"
Cause: A variable whose format does not support scaling was used in a SQL statement or embedded PL/SQL block. The following formats do not support scaling: PIC S9(n) COMP PIC S9(n) COMP-4 PIC S9(n) COMP-5 PIC S9(n) BINARY PIC 9(n) COMP
Action: Remove the scale or use a datatype that support scaling.