No. 5000 ~ 5999
5001: Datetime/interval precision is out of range.
Cause The values of DATETIME and INTERVAL do not match with the specified precision.
Action Correct the specified precision and try again.
5002: Invalid data type for this operation.
Cause An invalid data type was entered for an operation or function.
Action Check the entered data type.
5003: Invalid TIME value.
Cause Invalid TIME value.
Action Check each field of TIME.
5004: Invalid TIMESTAMP value.
Cause Invalid TIMESTAMP value.
Action Check each field of TIMESTAMP.
5005: Invalid DATE value.
Cause Invalid DATE value.
Action Check each field of DATE.
5006: Invalid DATETIME unit type.
Cause Invalid unit type for the entered DATETIME type.
Action Check the entered unit type.
5007: Invalid string length.
Cause Invalid format string or input string length.
Action Check if format string or input string is null or less than than 0.
5008: Invalid precision specified for fractions of a second.
Cause The precision specified for fraction of a second in TIMESTAMP and TIME is invalid.
Action Check whether the precision is between 0 and 9.
5009: Input string is too short for DATE format.
Cause The input string to be converted into the specified format string is incomplete.
Action Lengthen the input string to match the given format string.
5010: Format ends before the entire input string is converted.
Cause Additional unconverted data exists in the input string after conversion.
Action Check the definition of the DATETIME format code and correct the input string.
5011: Invalid DATE format.
Cause Invalid format code for DATE type is entered.
Action Verify the DATE format code used is valid.
5012: Invalid TIME format.
Cause Invalid format code for TIME/TIMESTAMP type is entered.
Action Verify the TIME/TIMESTAMP format code used is valid.
5013: Specified format code cannot be used as input format.
Cause The given format code cannot be used as input format.
Action Delete the invalid format code from format string.
5014: Specified format code is invalid.
Cause Unable to verify the specified format code.
Action Delete the invalid format code from format string.
5015: Duplicated YEAR format exists.
Cause A YEAR format code has already been provided.
Action Delete the duplicate YEAR format code.
5016: Duplicated MONTH format exists.
Cause A MONTH format code has already been provided.
Action Delete the duplicate MONTH format code.
5017: Duplicated DAY format exists.
Cause A DAY format code has already been provided.
Action Delete the duplicate DAY format code.
5018: Duplicated HOUR format exists.
Cause An HOUR format code has already been provided.
Action Delete the duplicate HOUR format code.
5019: Duplicated MINUTE format exists.
Cause A MINUTE format code has already been provided.
Action Delete the duplicate MINUTE format code.
5020: Duplicated SECOND format exists.
Cause A SECOND format code has already been provided.
Action Delete the duplicate SECOND format code.
5021: Duplicated fractions of a second format exists.
Cause Fractions of a second format code has already been provided.
Action Delete the duplicate fractions of a second format code.
5022: Duplicated AD/BC format exists.
Cause An AD/BC format code has already been provided.
Action Delete the duplicate AD/BC format code.
5023: Duplicated AM/PM format exists.
Cause An AM/PM format code has already been provided.
Action Delete the duplicate AM/PM format code.
5024: Month conflicts with Julian date.
Cause DDD format code and month-related format code cannot be used together.
Action Delete the month-related format code to use the DDD format code.
5025: Day of the month conflicts with Julian date.
Cause DDD format code and date-related format code cannot be used together.
Action Delete the date-related format code to use the DDD format code.
5026: Hour of the day conflicts with seconds in the day.
Cause SSSSS format code and hour-related format code cannot be used together.
Action Delete the hour-related format code to use the SSSSS format code.
5027: Minutes of the hour conflicts with seconds in the day.
Cause SSSSS format code and minute-related format code cannot be used together.
Action Delete the minute-related format code to use the SSSSS format code.
5028: Seconds of the minute conflicts with seconds in the day.
Cause SSSSS format code and second-related format code cannot be used together.
Action Delete the second-related format code to use the SSSSS format code.
5029: Invalid year value: must be a non-zero integer between -4713 and +9999.
Cause Invalid value specified for the year.
Action Input a non-zero integer value between -4713 and +9999.
5030: Invalid month value.
Cause Invalid value specified for the month.
Action Input an integer value between 1 and 12.
5031: Invalid month name.
Cause Invalid value specified for the month name.
Action Input a valid month name.
5032: Invalid day value.
Cause Invalid value specified for the day name.
Action Input a valid day name.
5033: Invalid hour value.
Cause Invalid value specified for the hour.
Action Input an integer value between 0 and 23.
5034: Invalid minute value.
Cause Invalid value specified for the minutes.
Action Input an integer value between 0 and 59.
5035: Invalid second value.
Cause Invalid value specified for the seconds.
Action Input an integer value between 0 and 60.
5036: Invalid fractions of a second value.
Cause Invalid value specified for the fractions of a second.
Action Input an integer value between 0 and 999999999.
5037: Invalid AD/BC value.
Cause Invalid value specified for AD/BC.
Action Input a valid value for AD/BC.
5038: Invalid AM/PM value.
Cause Invalid value specified for AM/PM.
Action Input a valid value for AM/PM.
5039: Signed year cannot be used with AD/BC.
Cause The signed year format cannot be used with the AD/BC format.
Action Delete one of the two formats to make a valid format string.
5040: HH24 cannot be used with AM/PM.
Cause The HH24 format cannot be used with the AM/PM format simultaneously.
Action Delete one of the two formats to make a valid format string.
5041: Invalid precision specified for fractions of a second.
Cause The precision for fractions of a second in TIMESTAMP and TIME is invalid in the format string.
Action Verify the precision is between 0 and 9.
5042: Invalid decimal input.
Cause Invalid value specified for decimal.
Action Input a valid decimal number ('.').
5043: Invalid seconds of the day input.
Cause Invalid value was entered in SSSSS format.
Action Input an integer value between 0 and 86400.
5044: Insufficient space in string buffer for DATETIME type.
Cause The buffer is not large enough to convert the DATETIME type to a string.
Action Increase the buffer size.
5045: Only TIME format can be omitted.
Cause All format codes except hour/minute/second/fraction of a second are omitted from the input string.
Action Input valid values for the format codes or delete the formats.
5046: Day of the year must be between 1 and 365 (366 for leap year).
Cause Invalid value specified for a day of the year
Action Input an integer value between 1 and 366.
5047: Invalid day name.
Cause Invalid value specified for a day of the week
Action Input a valid value for a day of the week.
5048: Too many truncation format specifiers.
Cause More than one truncate format code is set.
Action Input only one format code.
5049: Too many round-up format specifiers.
Cause More than one round-up format code is set.
Action Input only one format code.
5050: Invalid use of the escape character.
Cause Invalid use of the escape character.
Action Check the search pattern string of LIKE function.
5051: Invalid hexadecimal number.
Cause The given character is not a valid hexadecimal number.
Action Check the character to be converted to hexadecimal number.
5052: Invalid string sequence.
Cause The character is not included in the given character set.
Action Check the input string and character set.
5053: Invalid Unicode.
Cause Invalid Unicode.
Action Check the input string.
5054: Not implemented.
Cause Unsupported format string.
Action Check the input format string.
5055: Invalid type of UNIT used for INTERVAL.
Cause Invalid UNIT type for the INTERVAL type that was entered.
Action Check the UNIT type.
5056: Invalid input string for INTERVAL.
Cause An error occurred while converting the input string to INTERVAL type.
Action Check the input string.
5057: Invalid input precision for interval.
Cause Invalid leading precision value.
Action Check the leading precision value.
5058: Invalid precision value for fractions of a second.
Cause Invalid precision value for fractions of a second.
Action Input a valid precision value for fractions of a second.
5059: Invalid INTERVAL format.
Cause Unsupported interval format string.
Action Check the input format string.
5060: Month value is out of range.
Cause Value of months in YEAR-TO-MONTH INTERVAL type is out of range.
Action Input a valid month value.
5061: Hour value is out of range.
Cause Value of hour in DAY-TO-SECOND INTERVAL type is out of range.
Action Input a valid hour value.
5062: Minutes value is out of range.
Cause Value of minutes in DAY-TO-SECOND INTERVAL type is out of range.
Action Input a valid minutes value.
5063: Seconds value is out of range.
Cause Value of seconds in DAY-TO-SECOND INTERVAL type is out of range.
Action Input a valid seconds value.
5064: INTERVAL exceeds given precision value.
Cause The INTERVAL value does not match the given precision value.
Action Correct the values and try again.
5065: Divide by zero error.
Cause The INTERVAL type was divided by 0.
Action Modify the expression to remove the error.
5066: Insufficient space in buffer for conversion.
Cause The buffer is not large enough to convert the INTERVAL type into string.
Action Increase the buffer size.
5067: Output was altered or truncated to fit into buffer, resulting in a possible loss of precision.
Cause The buffer is not large enough to contain the results of the converted string.
Action Increase the buffer size.
5068: Overflow error.
Cause Overflow occurred as a result of an operation.
Action Decrease the value of an operand.
5069: Underflow error.
Cause Underflow occurred as a result of an operation.
Action Increase the value of an operand.
5070: Divide by zero error.
Cause The NUMBER type was divided by 0.
Action Modify the expression to remove the error.
5071: NUMBER exceeds given precision.
Cause The NUMBER value does not match the given precision value.
Action Correct the values and try again.
5072: Failure converting NUMBER to or from a native type.
Cause An error occurred while converting the NUMBER value.
Action Check that the value is within the appropriate range.
5073: Invalid NUMBER provided for the operation.
Cause An invalid NUMBER value was entered for the operation or function.
Action Change the value and try again.
5074: Given string does not represent a number in proper format.
Cause The given string does not represent a proper number.
Action Check the type of string.
5075: Invalid format string.
Cause Invalid format string.
Action Correct the format string.
5076: NUMBER is not printable in this format. Numbers were filled in output buffer.
Cause The NUMBER value does not match the given format.
Action Modify the NUMBER value or format string.
5077: NUMBER precision is out of range.
Cause The precision of the NUMBER type is out of range.
Action Specify a precision value for the NUMBER type between 1 and 38.
5078: NUMBER scale is out of range.
Cause The scale of the NUMBER type is out of range.
Action Specify a scale value for the NUMBER type between -125 and +130.
5079: Data type length is out of range.
Cause The length is out of range.
Action Modify the length to the one that is defined for each type.
5080: Invalid ROWID.
Cause Invalid ROWID
Action Choose a valid ROWID.
5081: Invalid ROWID segment info.
Cause Invalid ROWID segment information.
Action Input valid segment information for the ROWID.
5082: Invalid ROWID file.
Cause Invalid ROWID file information.
Action Input valid file information for the ROWID.
5083: Invalid ROWID block.
Cause Invalid ROWID block information.
Action Input valid block information for the ROWID.
5084: Invalid ROWID row.
Cause Invalid ROWID row information.
Action Input valid row information for the ROWID.
5085: Invalid IP string.
Cause Invalid IP string.
Action Check the input IP string.
5086: String buffer is too small for string conversion or copy.
Cause The string buffer is too small to handle the task.
Action Check the size of the input string.
5087: The date value is out of range.
Cause The date value of the YEAR-TO-MONTH INTERVAL type is out of range.
Action Input a valid date value.
5088: Numeric digits are not matched.
Cause The number of digits of a given number and the length of the datetime format are not matched.
Action Use the same number of digits as the length of the datetime format.
5089: Punctuation characters are not matched.
Cause The character of a given punctuation mark does not match the character of the datetime format.
Action Use the same character as that of the datetime format.
5090: Not a numeric value.
Cause Cannot use a character for numeric data.
Action Use numeric data.
5091: Invalid timezone format.
Cause Invalid timezone format is used for the TIMESTAMP type.
Action Verify that you have entered a valid timezone format.
5092: Duplicate TZH format.
Cause The TZH format code already exists.
Action Delete the duplicated timezone (hour) format code.
5093: Duplicate TZM format.
Cause The TZM format code already exists.
Action Delete the duplicated timezone (minute) format code.
5094: Duplicate TZR format.
Cause The TZR format code already exists.
Action Delete the duplicated timezone (region) format code.
5095: Duplicate TZD format.
Cause The TZD format code already exists.
Action Delete the duplicated timezone (abbreviation) format code.
5096: TZR/TZD format conflicts with TZH/TZM format.
Cause timezone region format cannot be used with timezone time format.
Action Delete the region format.
5097: TZH/TZM format conflicts with TZR/TZD format.
Cause timezone time format cannot be used with timezone region format.
Action Delete the time format.
5098: Invalid hour value of UTC offset.
Cause The hour value of UTC offset must be between -12 and 14.
Action Verify that you have entered a valid hour value of UTC offset.
5099: Invalid minute value of UTC offset.
Cause The minute value of UTC offset must be between 0 and 59.
Action Verify that you have entered a valid minute value of UTC offset.
5100: Invalid second value of UTC offset.
Cause The second value of UTC offset must be between 0 and 59.
Action Verify that you have entered a valid second value of UTC offset.
5101: Invalid hour value of daylight saving time.
Cause The hour value of daylight saving time must be between 0 and 24.
Action Verify that you have entered a valid hour value of daylight saving time.
5102: Invalid minute value of daylight saving time.
Cause The minute value of daylight saving time must be between 0 and 59.
Action Verify that you have entered a valid minute value of daylight saving time.
5103: Invalid timezone offset.
Cause The timezone offset value must be in the format of '[+ -]hh:mm'.
Action Verify that you have entered a valid timezone offset.
5104: Invalid timezone region value.
Cause The timezone region value is invalid or unsupported.
Action Verify that you have entered a valid timezone region value.
5105: Invalid timezone index '%1$d'.
Cause The timezone index value is not supported.
Action Contact the technical support team.
5106: Invalid timezone hour value.
Cause The timezone hour value is invalid.
Action Verify that you have entered a valid timezone hour value.
5107: Invalid timezone minute value.
Cause The timezone minute value is invalid.
Action Verify that you have entered a valid timezone minute value.
5108: Invalid timezone region value.
Cause The timezone region value is invalid.
Action Verify that you have entered a valid timezone region value.
5109: Invalid timezone abbreviation value.
Cause The timezone abbreviation value is invalid.
Action Verify that you have entered a valid timezone abbreviation value.
5110: Invalid date/time period according to the daylight saving time rule.
Cause The date/time period is invalid according to the daylight saving time rule.
Action Check the daylight saving time rule.
5111: NUMBER exceeds given precision. (n:%1$s, p:%2$d, s:%3$d)
Cause The NUMBER value does not match the given precision value.
Action Correct the values and try again.
5112: Duplicated '%1$s' format exists.
Cause A format code has already been provided.
Action Delete the duplicated format code.
5113: Invalid %1$s value '%2$s'. (%3$s)
Cause Invalid value specified for the %1$s.
Action Input a valid value for %1$s.
5114: Invalid %1$s value '%2$d': must be an integer between %3$d and %4$d.
Cause Invalid value specified for the %1$s.
Action Input a valid value for %1$s.
5115: Cannot find the timezone file.
Cause The timezone file does not exist, or you don't have permission to read the file.
Action Check the timezone file.
5116: NULL object instance access violation.
Cause An attempt was made to access the attributes of an object instance whose value is null.
Action Check that the value of the object instance is not null.
5117: Invalid user-defined type.
Cause The specified user-defined type does not exist or has been altered.
Action Check if the user-defined type has been altered on the server.
5118: FLOAT precision is out of range.
Cause The precision of the FLOAT type is out of range.
Action Specify a precision value for the FLOAT type between 1 and 120.
5119: Invalid number type.
Cause Invalid number type.
Action Check the type.
Last updated