DBMS_ALERT from trigger does not work, why?
From: Almut Herzog <al-her_at_sectra.se>
Date: 1996/09/09
Message-ID: <32343135.1122_at_sectra.se>#1/1
Date: 1996/09/09
Message-ID: <32343135.1122_at_sectra.se>#1/1
Hi,
I try to use the DBMS_ALERT package from a trigger and it will not work
though I can user DBMS_ALERT from the command line (see examples below)!
So it's not as easy as "run catproc" or "grant execute on SYS.DBMS_ALERT
to ME".
I never had trouble with this before, but I am not installing on my own
server but on someone else's (i.e. I have not much rights to go roaming
in the system and would anyway not know where to look).
Any suggestions?
Please reply by e-mail, too (it's faster!).
TIA,
Almut
Oracle7 Server Release 7.2.3.0.0 - Production Release
PL/SQL Release 2.2.3.0.0 - Production
CORE Version 3.4.3.0.0 - Production
TNS for HPUX: Version 2.2.3.0.0 - Production
NLSRTL Version 3.1.4.6.0 - Production
-- Almut Herzog SECTRA-Imtec AB e-mail: al-her_at_sectra.se Teknikringen 2 voice: ++46 13 235221 583 30 Linkoping fax: ++46 13 212185 SWEDENReceived on Mon Sep 09 1996 - 00:00:00 CEST