Query on Triggers..

Posted by RBA on Stack Overflow See other posts from Stack Overflow or by RBA
Published on 2010-05-12T10:58:41Z Indexed on 2010/05/12 11:04 UTC
Read the original article Hit count: 190

Filed under:
|

Created One Trigger in Oracle..

SQL> CREATE OR REPLACE TRIGGER student_after_insert
  2  AFTER INSERT
  3  ON student
  4  FOR EACH ROW
  5  BEGIN
  6     @hello.pl
  9  END student_after_insert;
 10  /

Contents of hello.pl are:-

BEGIN
   DBMS_OUTPUT.PUT_LINE('hello world');
END;

And.. the result is pretty good, as the content of hello.pl is displayed on screen while inserting a record..

Now, the query is -- When i change the content of the hello.pl file, after exiting from oracle, and then logging again, It doesn't shows the updated contents, instead it shows the previous content..

I noticed that, if i drop the trigger and create it again, then it is working fine.. Why is it happening so.. And what is the solution to this problem..

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about triggers