Errata

Oracle PL/SQL Language Pocket Reference

Errata for Oracle PL/SQL Language Pocket Reference

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Printed
Page 10
The heading of the 3rd column in the table at the center of the page

did read:

Oracle RDNMS Datatype

Now reads:

Oracle RDBMS Datatype

 Anonymous    Mar 01, 2001
Printed
Page 13

The 2nd sentence in the 2nd paragraph did read:

"For variable-length character sets (like JA16SJIS), the length
specification is in bytes; for fixed-length character sets, the it is
in characters."

Now reads:

"For variable-length character sets (like JA16SJIS), the length
specification is in bytes. For fixed-length character sets, the
specification is in characters."

 Anonymous    Mar 01, 2001
Printed
Page 20

At the bottom of the page, the code used to read:

"[cursor_name | SELECT statement]"

It now reads:

"[cursor_name | (SELECT statement)]"

 Anonymous    Oct 01, 1999
Printed
Page 60
Replaced the package example with the following

CREATE OR REPLACE PACKAGE time_pkg IS
FUNCTION GetTimestamp RETURN DATE;
PRAGMA RESTRICT_REFERENCES (GetTimestamp, WNDS);
PROCEDURE ResetTimestamp(inDate DATE DEFAULT
SYSDATE);
END time_pkg;

CREATE OR REPLACE PACKAGE BODY time_pkg IS
StartTimeStamp DATE := SYSDATE;
-- StartTimeStamp is package data.
FUNCTION GetTimestamp RETURN DATE IS
BEGIN
RETURN StartTimeStamp;
END GetTimestamp;
PROCEDURE ResetTimestamp(inDate DATE DEFAULT
SYSDATE) IS
BEGIN
StartTimeStamp := inDate;
END ResetTimestamp;
END time_pkg;

 Anonymous    Mar 01, 2001