Using dbms_alert

From: E Gokhman <egokhman_at_aol.com>
Date: 1995/08/30
Message-ID: <4235mo$6le_at_newsbf02.news.aol.com>#1/1

Hi,

For some reason, when I try to use dbms_alert in a store procedure inside of a package I get complaint, but when I execute dbms_alert statements by themselves (in sqlplus) it's ok. Here is the errors I get. I get no problems executing dbms_output.

Thanx in advance, Ed Gokhman

create procedure mywait(channel in varchar2) as

    message varchar2(256) := 'nothing';
    status integer := 0;
begin

   dbms_alert.register(channel);

   dbms_alert.waitone(channel, message, status, 0);

   if status = 0 then

        dbms_output.put_line(message);
   end if;

end mywait;
/

show errors;

Errors for PROCEDURE MYWAIT:

LINE/COL ERROR

-------- -----------------------------------------------------------------
5/5      PLS-00201: identifier 'DBMS_ALERT' must be declared
5/5      PL/SQL: Statement ignored
7/2      PLS-00201: identifier 'DBMS_ALERT' must be declared
7/2      PL/SQL: Statement ignored

SQL> --Count Edyulya, the man and the legend Received on Wed Aug 30 1995 - 00:00:00 CEST