MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Oracle 11g Workbook

with 2 comments

This is the errata for the Oracle Database 11g PL/SQL Programming Workbook. While you try to eliminate all errors when you write a book and I think we did a great job on this book because the errors are minimal. However, re-reading our own book and taking input from those who also read it, we find things missed or opportunities to improve clarity. This errata includes corrections of mistakes, suggestions for change, and improvements to the base text. If the book is successful, I’m sure they’ll make it into the next edition.

If you’re reading or read the book, please feel free to let me know of any uncaught error or suggestion that you may have. Thanks, Michael

Errata:
(Acknowledgment and corrections to Oracle Database 11g PL/SQL Programming Workbook)

Change Key:

removed text

added text

Chapter 2

Page 54:

The Guard Exit Loop drawing should have the exit from the decision diamond not the Iterative Step rectangle. The corrected Figure 2-2 should look like this:

Appendix A

Page 366:

The anonymous block is missing the declaration of the stmt variable, which can be a VARCHAR2 or CLOB based on the physical size of the sample function being wrapped. It’s a best practice to use a CLOB data type, and below is the complete working program unit.

SQL> DECLARE
  2    stmt    CLOB;
  3    SOURCE  DBMS_SQL.VARCHAR2S;
  4    SOURCE  DBMS_SQL.VARCHAR2S;
  5  BEGIN
  6    SOURCE(1) := 'CREATE FUNCTION two RETURN NUMBER IS ';
  7    SOURCE(2) := '  BEGIN ';
  8    SOURCE(3) := '    RETURN 2; ';
  9    SOURCE(4) := '  END;';
 10    RESULT := DBMS_DDL.WRAP(ddl => SOURCE, lb => 1, up => SOURCE.COUNT);
 11    FOR i IN 1..result.COUNT LOOP
 12      stmt := stmt || RESULT(i);
 13    END LOOP;
 14    EXECUTE IMMEDIATE stmt;
 15  END;
 16  /

Written by maclochlainn

May 2nd, 2013 at 12:36 am

Posted in Oracle 11g,pl/sql

2 Responses to 'Oracle 11g Workbook'

Subscribe to comments with RSS or TrackBack to 'Oracle 11g Workbook'.

  1. Hello,

    Could you please tell me where I can find the video store scripts that align with your Oracle Press 11g Pl/Sql Programming (2008)? I have had no luck on the Oracle Press website. And is there an errata page to go with the book.

    Thank you.

    Phil Miller

    14 Jan 16 at 7:17 am

  2. Phil,

    You can find the Oracle Database 11g PL/SQL Programming code here, and the Oracle Database 11g PL/SQL Programming Workbook code here.

    While I have an errata, it’s a PDF file. I’ll ask the publisher if they object to posting it because they’ve never put it on their site. They’ve had it since 2008.

    maclochlainn

    19 Jan 16 at 11:49 pm

Leave a Reply