As Published In July/August 2003

Your corrections, your opinions, and your requests: Here's your forum for telling us what's right and wrong in each issue of Oracle Magazine, and for letting us know what you want to read.

Missed the Exit

Is there something missing from Listing 4 in "Managing Exceptional Behavior" in the May/June 2003 issue of Oracle Magazine? Something on the order of an "Exit;" following the assignment of retval on line 15? The routine as it stands works, but it reads the whole list every time.
Bruce E. Wilson
bruce@bewilson.net

Here's the corrected listing:

Code Listing 4: A better book_from_list function

CREATE OR REPLACE FUNCTION book_from_list (
   list_in IN book_tabtype,
   title_in IN book.title%TYPE)
RETURN book%ROWTYPE

IS
   indx PLS_INTEGER;
   retval book%ROWTYPE;
BEGIN
   IF title_in IS NOT NULL
   THEN
      indx := list_in.FIRST;
      LOOP
         EXIT WHEN indx IS NULL;
         IF list_in(indx).title =

           title_in
         THEN
            retval := list_in(indx);
         END IF;
         indx := list_in.NEXT (indx);
      END LOOP;
   END IF;
   RETURN retval;
END;

New Error Packages Have Arrived

Thanks a lot for your article "Managing Exceptional Behavior" in the May/June 2003 issue of Oracle Magazine. This came to us just as we were going to start a new Oracle development project. I will take advantage of this way of handling errors. However, I was able to find the errpkg.pkg code but not the errnums.pkg on the OTN Web site.

Is that package available?
Mark Roth
RothM@stratcom.mil

errnums.pkg is available at /oramag/oracle/03-may/errnums.pkg.
errpkg.pkg is available at /oramag/oracle/03-may/errpkg.pkg.

Yes. Replace "desc" with "description". The corrected listing is posted at /oramag/oracle/03-mar/o23javaxml_l3.html.

Send Mail to the Editor Send your opinions about what you read in Oracle Magazine, and suggestions for possible technical articles to opubedit_us@oracle.com. Or click on the Write the Editors link on our Web site, /oraclemagazine. Letters may be edited for length and clarity and may be published in any medium. We consider any communications we receive publishable.

Not Content without Forms

I have your latest edition of Oracle Magazine by my side, and it still does not contain a single article on Oracle Developer. I would appreciate articles on Oracle Forms, Oracle Reports, and the like, plus a step-by-step article on implementing and configuring Oracle9i Real Application Clusters on Windows and UNIX platforms.
Dhimant Antani
dhimant_antani@rediffmail.com

Oracle Forms articles are planned for future issues of Oracle Magazine. There is a also a wealth of Oracle Forms content at /products/forms.

I Want My RSS

Is there an RSS feed for the Oracle Magazine site (/oramag)? If there is not a feed, would it not be a good idea to introduce one?
SteveF@yeovil-college.ac.uk

No RSS feed is planned for Oracle Magazine, but an RSS feed is planned for the OTN home page at .