Unfortunately I am not 'selecting' anything ... all the code is 'exec immediate' style. I know what you are trying to say, but in my requirements I'd rather _ignore_ it than ponder over it. Raj --- david wendelken <davewendelken@xxxxxxxxxxxxx> wrote: > re: not using "when others then null;" > > >> I use it on a regular basis in certain code of mine (on production > >> database that runs 24x7) > when I > >> DON'T want the exception to kill the processing. > > >not to mention Forms programs. Mighty handy when in-line select statements > >(not > >in an explicit begin/end block) start to give off more than one row... > > Well, if you are getting more than one row back for that select statement, > then your expectation > of what data would exist does not match what data actually exists. I think > hiding that is a > serious mistake! > Much better to discover the problem and fix the code to correctly handle the > situation rather > than ignore it. > > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ===== Best Regards Raj --------------------------------------------------------- select mandatory_disclaimer from company_requirements; __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail ---------------------------------------------------------------- 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 -----------------------------------------------------------------