Errata

Print Print Icon

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



Version Location Description Submitted By
Printed Page 4
2nd Colde block demonstrating the DECLARATION section

The following block should use data type of DATE instead of VARCHAR2(9)
as the 3rd code block explains the use of an EXCEPTION and obviously is meant to be
wrong to force the error message.

2nd Code block:
declare
l_right_now varchar2(9);
begin
l_right_now := sysdate;
dbms_output.put_line(l_right_now);
end;
/

Should be:
_admin@SCUKDEV2> declare
l_right_now DATE;
begin
l_right_now := sysdate;
dbms_output.put_line(l_right_now);
end;
/

 Anonymous 
Printed Page 107
2nd paragraph in the Tips section

The code sample in the tips shows:

DECLARE
TYPE v_curs_t is REF_CURSOR;
v_curs v_curs_t;

This should be:

DECLARE
TYPE v_curs_t is REF CURSOR;
v_curs v_curs_t;

Note, there is no "_" between REF and CURSOR.

 Anonymous 
Printed Page 239
PL/SQL Example

As far as I'm concerned, the l_str variable gets overridden all the time instead of being concatenated. So the function allowed_enames always returns 'ENAME IN )'.

 Anonymous