Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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