| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Trouble with DBMS_ALERT.SIGNAL in a trigger
From: Nnoor_at_cris.com (NNOOR) >>
The trigger has only one command in it:
dbms_alert.signal('test_alert','test_message');
But it won't compile. Gives compilation errors <<
Sinse your example looks good, and you can execute the package from sqlplus, all I can think of is, Does the table/trigger owner have 'execute' priviledge on the package?
Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own
advice -
Received on Tue Apr 28 1998 - 00:00:00 CDT
 |
 |