dbms_alert.package

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?

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 Received on Mon Jan 25 1999 - 11:27:56 CST