Calling stored procedure from DB triggers

[KVS Raju]

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

[Zafar A. Mohammed_1]

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

Thanks
Zafar

[R. Allan Hicks]

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

[KVS Raju]

Hi,

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

CREATE OR REPLACE TRIGGER
BEFORE/AFTER INSERT/UPDATE/DELETE
... ... ...
BEGIN
END;