The tables always exist. That exception "when others" is used for capture "%notfound" or other exceptions, such as "multiple rows found" (although it should not happen). Guang > > > Is the "when others" exception trying to capture errors like "table does > not exist" or is it only for a "%notfound" condition in case there is no > row in the table for "id =3D jid ;" ?=20 > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------