Operating System - HP-UX
1748123 Members
3427 Online
108758 Solutions
New Discussion юеВ

Calling stored procedure from DB triggers

 
KVS Raju
Advisor

Calling stored procedure from DB triggers

Hi,

Is it possible to call a stored procedure from Triggers in Oracle 7.3.2.

In Oracle 9i , it is possible.
CREATE OR REPLACE TRIGGER
BEFORE/AFTER INSERT/UPDATE/DELETE
...
...
..
CALL
like this

Thanks in Advance
Time and Tide wait for none
3 REPLIES 3
Zafar A. Mohammed_1
Trusted Contributor

Re: Calling stored procedure from DB triggers

You should be able to call the stored procedure from database triggers. I have to cross-check.

Thanks
Zafar
R. Allan Hicks
Trusted Contributor

Re: Calling stored procedure from DB triggers

I can't say that I've tried it, but it should work.

In replication, table triggers call packages, but that's 8i and higher.

I'd watch out for permission issues.

Do all users have execute permissions on the stored procedure?

If not, make sure via roles or some other method than when you add a user to the system they get execute permissions on the procedure as well as access rights to the table(s).


"Only he who attempts the absurd is capable of achieving the impossible
KVS Raju
Advisor

Re: Calling stored procedure from DB triggers

Hi,

It is possible.
we need to remove 'call' from syntax

CREATE OR REPLACE TRIGGER
BEFORE/AFTER INSERT/UPDATE/DELETE
... ... ...
BEGIN
END;
Time and Tide wait for none