2 Replies Latest reply: Oct 20, 2011 7:15 AM by user7048053 RSS

    11gR2 - DBMS_DST.END_UPGRADE example

    Nicolas.Gasparotto
      From "Example of Updating Daylight Saving Time Behavior"
      http://download.oracle.com/docs/cd/E11882_01/server.112/e10729/ch4datetime.htm#CBBHHBHG
      The call to DBMS_DST.END_UPGRADE is obviously wrong :
      After all the tables are upgraded, you can invoke END_UPGRADE to end an upgrade window, as in the following:
      BEGIN
      DBMS_DST.END_UPGRADE(:numfail OUT BINARY_INTEGER);
      END;
      +/+
      "OUT BINARY_INTEGER" should be removed.

      Nicolas.