/SQL/Work around for mutating problem in Oracle Triggers. Please check it out.

Work around for mutating problem in Oracle Triggers. Please check it out.

CREATE OR REPLACE TRIGGER trg_check_salary_bs
BEFORE insert or update OF salary,manager_id   /* statement-level trigger */
ON employees  
BEGIN
     trg_check_pkg.init_data;
END;
/

Source: srikanthtechnologies.com

Similar codes

0 vote245 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote252 views1 answer
Oracle sql winter time change
SQL
0 vote261 views3 answers
Postgresql grant alter table to user
SQL
0 vote254 views1 answer
Grouping by email domain mysql
SQL
0 vote274 views1 answer
Doesn't have default value mysql
SQL
1 vote269 views1 answer
Where date = max(date) in sql
SQL
0 vote254 views1 answer
Except in sql
SQL
0 vote250 views1 answer
Mod in sql
SQL
7 votes269 views4 answers
Lowest salary in sql
SQL
0 vote249 views1 answer
NLS_NCHAR_CHARACTERSET
SQL