Re: dbms_alert.package

Hi,

I think you've fallen into the obvious pitfal, privileges...

Most likely dbms_alert is owned by sys and you don't have permissions on it.

You can check it by executing:
select * from all_objects where object_name = 'DBMS_ALERT';

If nothing is returned you cannot even see the package.

Login as SYS or as INTERNAL and give yourself permissions (suppose you'se SCOTT): grant execute on dbms_alert to SCOTT;

That should do it.

If the package is not there at all, then ask someone to install the "procedural option" for Oracle (is it called oraproc.sql ?). That should install all the necessary bits and bops.

Regards, Gerrit-Jan Linker
Developer of Oraxcel and OraDebug
http://members.aol.com/gjlinker

In article <36aca2bd.1065076138_at_nntp.statoil.no>, riise_at_bgnett.no (Johan Ur Riise) writes:

>i want to use the dbms_alert package to signal another process that
>something has been changed.
>
>it looks like i cannot use the function call
> dbms_alert('sigma',999);
>in a stored procedure nor in a packaged procedure nor a java program.
>
>the java snip:
> CallableStatement stmalert = conn.prepareCall
> "begin dbms_alert.signal(:1,:2); end;" ) ;
>
>the error message is
> 3/3 PLS-00201: identifier 'SYS.DBMS_ALERT' must be declared
> 3/3 PL/SQL: Statement ignored
>
>i can use it in sqlplus directly, and in an anonymous block in the c++
>oci template library (by Sergei Kuchin).
>
>this is true for functions in package dbms_pipe too.
>this means i have noe way to call this function in my client program.
>ideas?
Received on Mon Jan 25 1999 - 17:09:35 CST