Errata for Oracle PL/SQL Programming
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.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update
On page 582 of this book, near the top, it says that an OUT parameter is
Write-only. This is incorrect; An OUT parameter can be read as well as
written to, as a simple test will prove.
On the next page, 583, it says "You cannot assign an OUT parameter's value
to another variable or even use it in a reassignment to itself."
This too is incorrect. You can assign the parameter's value to another
variable -- once again, as a simple test will prove.
This procedure works:
(p_timestamp_string IN VARCHAR2,
p_timestamp_date OUT DATE)
p_timestamp_date := TO_DATE(p_timestamp_string, 'YYMMDDHH24MI');
v_date := p_timestamp_date;
||Apr 01, 2013