trigger and multiple procedure?

[slok]

whenever I insert/update/delete an employee_salary table, I need to
1. write to an audit table , procedure write_audit
2. check whether salary has reached limit, procedure check_sal

I have 2 procedures to handle point "1" and point "2".
But how can I do a trigger that will invoke these 2 procedures?

 

[manojbajaj]

Hi,
You can write before insert,update,delete trigger on table and when inserting or updating u call check_sal and autdit
when deleting u may call only audit. for sepcifc syntax refer to any oracle book