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.

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 12
rd paragraph

Minimum value of a NUMBER is not 1.0E-129 but 1.0E-130 according to your own "Oracle PL/SQL programming". Which is correct value:)

 Geert Jansen  Apr 23, 2010 
PDF Page 21
bottom

min_order_qty NUMBER(1) CONSTANT := 5;

shoul be:

min_order_qty CONSTANT NUMBER(1) := 5;

 1ac0  May 16, 2014 
Printed Page 21
4th Paragraph

The example constant declaration is not correct.
It should be

min_order_qty CONSTANT NUMBER(1) := 5;

The CONSTANT keyword is in the wrong place.

 Adrian Dillon  May 08, 2019 
PDF Page 27
bootom of the page under "For example"

I've fount this line not working:

DBMS_OUPUT.PUT_LINE('We are here!);

It should be changed with:

DBMS_OUTPUT.PUT_LINE('We are here!');

Missing "T" in "DBMS_OUPUT", and " ' " in "('We are here!);" after exclamation.

 sunrutcon  Jun 14, 2013 
Printed Page 49
top section paragraph - forth bullet

RPCs CAN be used to pass cursor variables, to non-oracle host with gateway.

Why is this a significant footnote?

There is increasing use of data and process distribution with SQL Server and Open Source.

The Siebel Analytics Server (BIEE Server) is powered by SQLAnywhere, and makes use of this displacement construct for condensing high performance distributed queries.

 Anonymous  Nov 03, 2008 
PDF Page 59
bottom

bad:
INSERT INTO emp VALUES (emp_rec);

good:
INSERT INTO emp VALUES emp_rec;

 1ac0  May 13, 2014 
PDF Page 143
top

bad:
INSERT INTO emp VALUES (emp_rec);

good:
INSERT INTO emp VALUES emp_rec;

 1ac0  May 13, 2014