Re: dbms_standard package or how to display info to user, please help

doug.moloney_at_ae.ge.com wrote:
>
> Before 7.3, Oracle included a package called dbms_standard, this had a
> function 'raise_application_error'. According to my DBA, oracle is not
> going to support this package in 7.3. Is there any other function that
> will raise a message to a user. I am on Unix, Oracle 7.3, creating a
> Powerbuilder Win95 GUI interface to the database. Basically, this
> allowed me to create my own error messages to display to the user within
> a trigger or procedure. Is there another function that will raise a
> message box so I can display a message?

  It continues to support. Following is an extract from dbmsstdx.sql

• Trigger Operations procedure raise_application_error(num binary_integer, msg varchar2, keeperrorstack boolean default FALSE);

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.