trigger not firing? 1

[joeythelips]

Hi i have created the following trigger to write out a line of text after an insert or update:

However, although the trigger gets created without any problems, the text does not write out after the commit?

SQL> ed
Wrote file afiedt.buf

1 create or replace trigger policy
2 after insert or update
3 on emp
4 begin
5 dbms_output.put_line('howya head');
6* end;
SQL> /

Trigger created.




SQL> ed
Wrote file afiedt.buf

1 insert into emp(empno,ename)
2* values(280,'tommy')
SQL> /

1 row created.

SQL> commit;

Commit complete.

SQL>

 

[Dagon]

Need "set serveroutput on" to see the output.

 

[joeythelips]

thanks alot

Joe