Oracle Error OCI-01862: wrong number of digits for this format item

Oracle Error Message

OCI-01862: wrong number of digits for this format item

Reason for the Error

The number of digits used for this format item is not equal to the number necessary for this format when specifying Format eXact (“FX”) for this item.

Solution

Fill out this format item with leading zeros to the number necessary for this format. (This is generally the number of characters in the format code–DD needs 2 digits, for example. The exceptions are HH24 & HH12, which both need 2, and J, which needs 9.)

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...