Release 8.0.4
A58312-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8 Error Messages Release 8.0.4 A58312-01 |
|
This section lists messages generated when the Oracle date function is accessed.
Cause: A literal specified in a date format was too large. If a literal is entered as a date, it must be less than 220 characters long.
Action: Use only literals less than 220 characters long in the date format.
Cause: The date format string was too long to process. This should occur only if several long literals are specified as part of a date.
Action: Remove long literals from the date format string.
Cause: An invalid Julian date was entered. Valid Julian dates run from 1 to 3,442,447.
Action: Enter a valid Julian date between 1 and 3,442,447.
Cause: This is an internal error message that is not likely to occur. It is usually caused by a failure in the system clock.
Action: Investigate the system clock and the process that requested the date or time. If necessary, contact customer support.
Cause: A format code was listed twice in a date specification. Each format code may be specified only once in the function TO_DATE.
Action: Remove the duplicate format code from the date specification, then retry the operation.
Cause: Both a Julian date and a day of the year were specified in the TO_DATE function. If a Julian date is specified, the day of the year (DDD) may not be specified, as it is contained in the Julian date.
Action: Remove the day of the year or the Julian date from the specification, then retry the operation.
Cause: More than one year format code was listed in a date specification. Only one of the following year format codes may be specified in a date: YYYY, YYY, YY, Y.
Action: Remove all but one year format from the date specification.
Cause: More than one hour format code was listed in a date specification. Only one of the following hour format codes may be specified in a date: HH, HH12, HH24.
Action: Remove all but one hour format from the date specification.
Cause: Both types of meridian indicators, AM and PM, were listed in a date specification. If one of the meridian indicator format masks, such as AM or A.M., is specified in the date, the other may not be specified.
Action: Use one meridian indicator format, with or without periods, consistently.
Cause: More than one hour format code was listed in a date specification. Only one of the following hour format codes may be specified in a date: HH, HH12, HH24.
Action: Remove all but one hour format from the date specification.
Cause: Both types of meridian indicators, AM and PM, were listed in a date specification. If one of the meridian indicator format masks, such as AM or A.M., is specified in the date, the other may not be specified.
Action: Use one meridian indicator format, with or without periods, consistently.
Cause: Both types of BC/AD indicators were listed in a date specification. If one of the BC/AD indicator format masks, such as BC or B.C., is specified in the date, the other may not be specified.
Action: Use one BC/AD indicator format, with or without periods, consistently.
Cause: More than one month format code was listed in a date specification. Only one of the following month format codes may be specified in a date: MM, MON, MONTH.
Action: Remove all but one month format from the date specification.
Cause: More than one day-of-the-week format code was listed in a date specification. Only one of the following day-of-the-week format codes may be specified in a date: D, DY, DAY.
Action: Remove all but one day-of-the-week format from the date specification.
Cause: A date specification contained both a 24-hour time format code and a meridian indicator code. If hours are specified using the 24-hour time format (HH24), a meridian indicator, AM or PM, may not be specified.
Action: Remove the meridian indicator format code, AM/PM or A.M./P.M., or the 24-hour time format code, HH24, from the date specification.
Cause: A date specification contained both a signed year and a B.C./A.D. indicator. If the year is specified with a sign, such as SYYYY, then B.C. or A.D. is implicit in the date and must not be entered.
Action: Remove the B.C./A.D. indicator from the date specification.
Cause: A date specification contained an invalid format code. Only the following may be specified when entering a date: year, month, day, hours, minutes, seconds, Julian day, A.M./P.M. and B.C./A.D.
Action: Remove the invalid format code from the date specification.
Cause: A date specification contained an invalid format code.
Action: Check that only valid date format codes are specified.
Cause: An era format code, E or EE, was specified with a calendar which does not use era information.
Action: Retry the operation using a date format mask which does not contain era format codes.
Cause: A valid date format picture included extra data. The first part of the format picture was converted into a valid date, but the remaining data was not required.
Action: Check the specifications for date format pictures and correct the statement.
Cause: The wrong year was specified with a Julian day. If a year is specified with a Julian date, it must be the year in which the Julian date occurs.
Action: Remove the year value from the date specification or enter the correct year for the Julian date.
Cause: A Julian date was specified with the day of the year but the day did not correspond to the Julian date. If the day of the year is specified with a Julian date, it must be the same day as the Julian date.
Action: Remove the day of the year value from the date specification or enter the correct day for the Julian date.
Cause: The wrong month was specified with a Julian date. If a month is specified with a Julian date, it must be the month in which the Julian date occurs.
Action: Remove the month value from the date specification or enter the correct month for the Julian date.
Cause: A Julian date was specified with the day of the month, but the month day did not correspond to the Julian date. If the day of the month is specified with a Julian date, it must be the same day of the month as the Julian date.
Action: Remove the day of the month value from the date specification or enter the correct day of the month for the Julian date.
Cause: A Julian date was specified with the day of the week, but the weekday did not correspond to the Julian date. If the day of the week is specified with a Julian date, it must be the same day of the week as the Julian date.
Action: Remove the day of the week value from the date specification or enter the correct day of the week for the Julian date.
Cause: The wrong hour was specified with seconds in the day. If an hour is specified with seconds past midnight (SSSSS), it must be the hour in which the seconds value falls.
Action: Remove the hour value from the date specification or specify the correct hour for the seconds past midnight.
Cause: A date specification contained both minutes of the hour and seconds in the day but the values did not correspond. If both minutes in the hour (MI) and seconds past midnight (SSSSS) are specified, the minutes value must be the minute in which the seconds value will occur.
Action: Remove the minutes value from the date specification or enter the correct minute value for the specified seconds value.
Cause: A date specification contained both seconds of the minute and seconds in the day but the values did not correspond. If both types of seconds are specified, the seconds of the minute value (SS) must be the second in which the seconds past midnight value (SSSSS) will fall.
Action: Remove the seconds of the minute value from the date specification or enter a value that corresponds to the given seconds in the day.
Cause: The day of the month specified in the date is invalid for the given month. The day of the month (DD) must be between 1 and the number of days in the month.
Action: Enter a valid day of the month for the specified month.
Cause: The data to be converted to date format was incomplete; the date format picture was longer than the input data.
Action: Either add more input or shorten the date picture format, then retry the operation.
Cause: A date specified a year that is not in the valid date range. A valid date is any date between January 1, 4712 B.C. and December 31, 4712 A.D.
Action: Enter a valid date value between 4712 B.C. and 4712 A.D.
Cause: An invalid value was specified for the quarter of the year in a date. The quarter (Q) must be between 1 and 4.
Action: Enter a value for quarter between 1 and 4.
Cause: A date specified an invalid month. Valid months are: January-December, for format code MONTH, and Jan-Dec, for format code MON.
Action: Enter a valid month value in the correct format.
Cause: An invalid value was specified for the week of the year in a date. Week of the year (WW) must be between 1 and 52.
Action: Enter a week of the year value between 1 and 52.
Cause: An invalid value was specified for the week of the month in a date. Week of the month (W) must be between 1 and 5.
Action: Enter a week of the month value between 1 and 5.
Cause: A date specified an invalid day of the week. Valid days are
Action: Enter a valid day of the week value in the correct format.
Cause: The day of the month listed in a date is invalid for the specified month. The day of the month (DD) must be between 1 and the number of days in that month.
Action: Enter a valid day value for the specified month.
Cause: An invalid day of the year was specified in a date. Day of the year (DDD) must be between 1 and 365 for a non-leap year or 1 and 366 for a leap year.
Action: Enter a day of the year value between 1 and 365 (or 366).
Cause: An invalid hour was specified for a date using the 12-hour time format. If a 12-hour format code (HH or HH12) is used, the specified hour must be between 1 and 12.
Action: Enter an hour value between 1 and 12.
Cause: An invalid hour was specified for a date using the 24-hour time format. If the 24-hour format code (HH24) is listed, the specified hour must be between 0 and 23.
Action: Enter an hour value between 0 and 23.
Cause: An invalid minute value was specified in a date. Minutes must be between 0 and 59.
Action: Enter a minute value between 0 and 59.
Cause: An invalid seconds value was specified in a date. Seconds must be between 0 and 59 if the seconds format code (SS) is used.
Action: Enter a seconds value between 0 and 59.
Cause: An invalid value for seconds in the day was specified in a date. Seconds must be between 0 and 86399 if the seconds past midnight format code (SSSSS) is used.
Action: Specify a seconds value between 0 and 86399.
Cause: An invalid Julian date was entered.
Action: Correct and retry.
Cause: A date specification contained a meridian indicator format code but a valid meridian indicator was not specified. If a meridian indicator code, A.M./P.M. or AM/PM, is included in a date format, the date must include a valid meridian indicator.
Action: Specify the meridian indicator in the correct format, A.M./AM or P.M./PM.
Cause: A date specification contained a BC/AD format code but a valid BC/AD indicator was not specified. If one of the BC/AD format codes, BC/AD or B.C./A.D., is specified in a date format, the date must include BC/B.C. or AD/A.D.
Action: Specify the BC/AD indicator in the date using the correct format.
Cause: An incorrect time zone code was specified for the NEW_TIME function.
Action: Correct the invalid time zone code, then retry the operation.
Cause: The input data to be converted using a date format model was incorrect. The format model expected a number but found a non-numeric character.
Action: Check the input data and the date format model to make sure the elements match in number and type, then retry the operation.
Cause: The input data to be converted using a date format model was incorrect. The format model expected a letter but found a non-alphabetic character.
Action: Check the input data and the date format model to make sure the elements match in number and type, then retry the operation.
Cause: A week number outside the range 1 to 53 was specified.
Action: Use only a value within the valid range for the week number.
Cause: Literals in the input string must be the same length as the literals in the format string, except for the leading white space characters. If the "FX" modifier is specified, the literal must match exactly, including the leading white space.
Action: Correct the format string to match the string literal.
Cause: The number of digits in this format item is not equal to the number required for the format. This error usually occurs when the "FX" modifier (format exact) has been specified.
Action: Resubmit the command using the required amount of numbers for the format mask.
Cause: The year is not supported for the current calendar.
Action: Please check the documentation to find out what years are supported for the current calendar.
Cause: Your calendar does not extend to the specified date.
Action: Specify a date which is legal for this calendar.
Cause: Era input does not match a known era.
Action: Provide a valid era on input.
Cause: While trying to truncate or round dates, extra data was found in the date format picture.
Action: Check the syntax of the date format picture and retry.
Cause: An invalid precision code was specified in a date.
Action: Enter a valid precision code in the date format. Valid precision types are: century, year, month, day, Julian date, hours, minutes, and seconds.
