Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling DBMS_ALERT from a package.
Dear Jens,
There is the possibility, that the dbms_alert package has no public - grant, I think you can check that with
select * from all_tab_grants
where owner='SYS' and table_name like 'DBMS%';
if there is no entry for dbms_alert, try to grant the execute privilege either to PUBLIC or to your user only. (grant execute on dbms_alert to my_user; -- you must be connected as SYS)
greetinx,
werner rammer
Jens Fudickar wrote:
> 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
>
> ------------------------------------------------------------------------
>
> Jens Fudickar <jens.fudickar_at_mni.fh-giessen.de>
> Softwareentwicklung
>
> Jens Fudickar
> Softwareentwicklung <jens.fudickar_at_mni.fh-giessen.de>
> Rodheimer Str. 42 Work: +49-641-960227
> Gießen Fax: +49-641-960228
> 35398 Home: +49-641-960227
> Deutschland Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name Fudickar
> First Name Jens
> Version 2.1
Received on Tue Jul 07 1998 - 07:59:21 CDT