This discussion is archived
2 Replies Latest reply: Oct 20, 2011 5:15 AM by user7048053 RSS

11gR2 - DBMS_DST.END_UPGRADE example

Nicolas.Gasparotto Oracle ACE
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points