ORA_DST_ERROR is useful when you are changing the time zone data file for your database. The function takes as an argument a datetime expression that resolves to a
ZONE value or a
VARRAY object that contains
ZONE values, and indicates whether the datetime value will result in an error with the new time zone data. The return values are:
0: the datetime value does not result in an error with the new time zone data.
1878: the datetime value results in a "nonexisting time" error.
1883: the datetime value results in a "duplicate time" error.
This function can be issued only when changing the time zone data file of the database and upgrading the timestamp with the time zone data, and only between the execution of the
BEGIN_PREPARE and the
END_PREPARE procedures or between the execution of the
BEGIN_UPGRADE and the
Oracle Database Globalization Support Guide for more information on time zone data files and on how Oracle Database handles daylight saving time, and Oracle Database PL/SQL Packages and Types Reference for information on the