ERROR: PLS-00201

[Quoted]     While porting some PL/SQL from 7.1 to 7.3 I ran across the following problem (simplified example):

PROCEDURE send_change_alert( alert_msg IN VARCHAR ) IS
BEGIN
    DBMS_ALERT.SIGNAL( 'test_signal', alert_msg ); END send_change_alert;

Which results in the following error:

ERROR: PLS-00201: identifier 'SYS.DBMS_ALERT' must be declared

But now if I run the following in sqlplus,

begin

    DBMS_ALERT.SIGNAL( 'test_signal', 'This test works.' ); end;
/

Everything works as expected. A check of the synonyms shows:

[Quoted] SQL> select * from dba_synonyms where synonym_name = 'DBMS_ALERT';

OWNER                          SYNONYM_NAME


------------------------------ ------------------------------


TABLE_OWNER                    TABLE_NAME


------------------------------ ------------------------------

PUBLIC                         DBMS_ALERT
SYS                            DBMS_ALERT

Has anyone seen this before? What am I missing here?

Thanks in advance,
John Kroll Received on Sat Aug 15 1998 - 03:14:22 CEST