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 |