Oracle PL/SQL Programming, 2nd Edition
by Steve Feuerstein, with Bill Pribyl


The following are the changes made in the 12/00 reprint.


Here's a key to the markup:

        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification


{13} The last sentence in the fifth paragraph did read: 
	
	"These subtypes include Natural (all integers greater than zero,..."

Now reads:

        "These subtypes include Natural (all integers greater than or equal to
        zero,..."


(67) The first line under the table did read: 

	"prefer the new line format,..."

Now reads:

        "I prefer the new line format,..."


[70] In the last line on the page, change "WHEN OTHERS" to "WHEN NO_DATA_FOUND."


(129) The first line in the quote in the "Avoid Recycling Variables" section
did read: 

	"...I use in your..."

Now reads: 

	"...I use in my..."


(158) At the end of the first paragraph under "The SET TRANSACTION Statement,"
changed "...four flavors:" to "...four flavors. Flavor 1:".


(159) At the end of the first paragraph on the page, changed "...consistent:" 
to "...consistent. Flavor 2:".


(159) At the end of the second paragraph, changed "...read-write:" to 
"...read-write. Flavor 3:".  


(159) At the end of the fourth paragraph, changed "...released:" to 
"...released. Flavor 4:". 


[167] The 5th and 6th lines of code did read:

         FROM employees emp, employee_type emptyp
        WHERE emp.type_code = emptyp.type_code;

Now read:

          FROM employee_type
        WHERE type_code = :emp.type_code


{175} In the last code sample, the 3rd line did read:

        FETCH green_eggs_cur INTO amount_of_ham, num_rejections, reason;

Now reads:

        FETCH green_eggs_cur INTO ham_amount, refused_count, lousy_excuse;


{177} The 5th line of the second code sample now reads:

        TO_CHAR (5000-company_rec.total_sales, '$9999'));

Should read:

        TO_CHAR (5000-comp_rec.total_sales, '$9999'));


(180) The last sentence in the third paragraph in the section "The %FOUND 
Attribute" did read: 

        "...%NOTFOUND attribute is set to TRUE..."

Now reads: 

        "...%FOUND attribute is set to FALSE..."


{180} The last line in the 1st code sample under "The %FOUND Attribute" did 
read:

        CLOSE call_cur;

Now reads:

        CLOSE caller_cur;


{181} In the code sample at the top of the page, changed: 

        ELSE 

to:

        ELSEIF :order.count_orders = 1


{181} The last line on the page did read:

        EXIT WHEN caller_rec%NOTFOUND;

Now reads:

        EXIT WHEN caller_cur%NOTFOUND;


{182} The 5th line in the first code sample did read:

        WHERE TO_NUMBER (TO_CHAR (order_date)) = 1993

Now reads:

        WHERE TO_NUMBER (TO_CHAR (order_date, 'YYYY')) = 1993


{211} The 16th line in the code sample was missing a semicolon.  It now reads:

        record_locked EXCEPTION;


{291} The 13th line of the 1st code example under "SELECT INTO from an 
Implicit Cursor" did read:

        WHERE sold_on BETWEEN < ADD_MONTHS (SYSDATE, -3);

Now reads:

        WHERE sold_on < ADD_MONTHS (SYSDATE, -3);


{292} The second code line on the page did read:

        WHERE sold_on BETWEEN < ADD_MONTHS (SYSDATE, -3);

Now reads:

        WHERE sold_on < ADD_MONTHS (SYSDATE, -3);


(381) In the second paragraph, changed:

        "to the built-in DBMS_OUTPUT package"

to:

        "to the built-in DBMS_OUTPUT package (see disk version)"


(434) In the 9th entry in the "Description" column (SSSSS), changed "1 through
86399" to "0 through 86399."


(472) The last line of code in both the first and second bulleted items did
read: 

	END

They now read: 

	END;


(509) In the paragraph at top of the page, changed "...the local module..." 
to "...the particular module of interest..."


[896] In the last paragraph, changed "...following scripts:" to "...following
scripts, compdbg and trace.sql:".


(902) The second sentence in the fifth paragraph on the page did read:
	
	"...earlier in the article..."

Now reads: 

	"...earlier in this chapter..."


(928) The third sentence on the page did read: 

	"...executing the DBMS..."

Now reads: 

	"...executing a program in the DBMS..."


(928) In line 4 of the first paragraph, deleted the extra space between 
"DBMS_" and "AQADM."


(928)  In line 5 of the first paragraph, deleted the extra space between 
"USER_QUEUE_" and "TABLES."


[947] The last line of first paragraph under "DBMS_SHAPSHOT" did read:

	"...see Chapter 16 in the Oracle7 Server Administrator Guide."

Now reads:

	"check the lastest version of the Server Administrator Guide in Oracle 
	documentation."


(952)  In the second-to-last code listing on the page, changed: 

	"...LAST_ERROR_POSTITION..." 

to:

	"...LAST_ERROR_POSITION..."


(966) Deleted the following entry from the index: 

        Boolean
           functions returning, 491