Re: dbms_alert.package

On Mon, 25 Jan 1999 17:27:56 GMT, i wrote:
>it looks like i cannot use the function call
>dbms_alert.signal('sigma',999);
>in a stored procedure nor in a packaged procedure nor a java program.
>PLS-00201: identifier 'SYS.DBMS_ALERT' must be declared

On 25 Jan 1999 23:09:35 GMT, gjlinker_at_aol.com (Gjlinker) wrote:
>grant execute on dbms_alert to SCOTT;

and on Mon, 25 Jan 1999 17:57:59 GMT tkyte_at_us.oracle.com (Thomas Kyte) wrote:
>roles are never enabled during the execution of a procedure.
[...]
>If you can do it in plus with no roles you can do it in a procedure.
>If you can't, you must have the privelege from a role and hence
>won't be able to do it in a procedure.

it worked, thanks to both of you.

the owner of the package where i use the dbms_alert functions, was granted (from SYS directly) the privilege to execute dbms_alert. before that, it probably had the right via the dba role (though i could no see that in table_privileges).

johan Received on Tue Jan 26 1999 - 03:50:47 CST