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


Here are the changes that were made in the 11/98 reprint:


[94] bullet item 1, "Database to variable conversion", sentence 2  
  
  "When you SELECT or FETCH data from a CHAR database column into a 
   VARCHAR2 variable, the trailing spaces are trimmed automatically."

changed to

  "When you SELECT or FETCH data from a CHAR database column into a 
   VARCHAR2 variable, the trailing spaces are retained."


{504} under "Default Values", first sentence

   "As you have seen from previous examples, you can provide a default 
    value for both IN and IN OUT parameters."

changed to

   "As you have seen from previous examples, you can provide a default 
    value for IN parameters."


{525} under para. 1, added this paragraph:

    "Private elements in a package must be defined before they can be
    referenced by other elements of the package. If, in other words, a
    public procedure calls a private function, that function must be 
    defined <italic>above</italic> the public procedure in the package
    body. You can, alternatively, use a forward declaration if you wish to
    keep your private programs at the bottom of the package body (see
    Chapter 15, Procedures and Functions, Forward Declarations)."