From: smagdaddy@aol.com
Subject: Re: How to change error_level in Forms?
Date: 1996/12/19
Message-ID: <19961219012400.UAA07358@ladder01.news.aol.com>#1/1
references: <594e68$kec@news.rl.af.mil>
organization: AOL http://www.aol.com
newsgroups: comp.databases.oracle.tools
x-admin: news@aol.com



Another way to trap these errors,  is to use the on-error trigger. Trap
only those errors that you want to suppress, matbe some others you want to
modify the message on,  and still have the real errors shine through. 
   I use these triggers and the DBMS_ERRORTEXT to help with debugging.

  see the online help for a pretty good example.
  You will probably want the on_message trigger also.



Rodger Hollingsworth
--------------------------------
US Navy  (DBA, Dev2K, SCO Unix)
You'll never get it unless you ask,  Then again you may not even if you do
ask.