Calling DBMS_ALERT from a package.

Hello all together.

I have a problem calling a function from the DBMS_ALERT package from my own package or stored procedure.

This is a test-procedure.
CREATE OR REPLACE PROCEDURE test88 IS
BEGIN
  dbms_alert.signal ('test', 'Test');
END test88;

Compiling this raised the following compiler-message: PLS-00201 : identifier "SYS.DBMS_ALERT" must be declared.

Calling this package from an anonymous block, there is no problem. BEGIN
  dbms_alert.signal ('test', 'Test');
END ; Can anyone tell me, what i have to do, to call a procedure form the DBMS_ALERT Package.

The same problem is with DBMS_PIPE, but there is no problem with DBMS_OUTPUT. Hope, that anyone can help me.

Jens

Viel Erfolg

Received on Mon Jul 06 1998 - 07:22:55 CDT