Oracle PL/SQL Programming

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



Version Location Description Submitted By Date Submitted
Printed Page 582-583
.

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: PROCEDURE Parse_HC (p_timestamp_string IN VARCHAR2, p_timestamp_date OUT DATE) AS v_date DATE; BEGIN p_timestamp_date := TO_DATE(p_timestamp_string, 'YYMMDDHH24MI'); v_date := p_timestamp_date; END Parse_HC;

Anonymous  Apr 01, 2013