| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_alert.package
A copy of this was sent to riise_at_bgnett.no (Johan Ur Riise)
(if that email address didn't require changing)
On Mon, 25 Jan 1999 17:27:56 GMT, you wrote:
>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
>
roles are never enabled during the execution of a procedure.
Try this:
SQL> set role none;
SQL> "statement you want to test to see if it'll work in 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.
You probably have the privelege to do what you are trying to do in the procedure via a role. Grant the privelege directly to the owner of the procedure and it'll work.
grant execute on dbms_alert to <OWNER>;
>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?
>
>
>context:
>Oracle7 Server Release 7.3.4.0.0 - Production
>With the distributed option
>PL/SQL Release 2.3.4.0.0 - Production
>ibm aix server
>
>oracle java thin drivers for winxxx
>
>regards
>johan
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Jan 25 1999 - 11:57:59 CST
 |
 |