AW: Trigger question

2004-07-14 Thread Anhaus, Thomas
Mathias Stroedler wrote : > >Hello, > >The statement gives an error? Why? What to do? Which from list? > >create trigger testtrigger for t2 after insert, update execute ( >if(New.t1_id =null) then >stop(37892493,'a message'); >) > > Error --- >Auto Commi

RE: Trigger question

2004-07-14 Thread Stoedtler, Mathias
AM To: [EMAIL PROTECTED] Subject: Trigger question Hello, The statement gives an error? Why? What to do? Which from list? create trigger testtrigger for t2 after insert, update execute ( if(New.t1_id =null) then stop(37892493,'a message'); ) Error -

Trigger question

2004-07-14 Thread Stoedtler, Mathias
Hello, The statement gives an error? Why? What to do? Which from list? create trigger testtrigger for t2 after insert, update execute ( if(New.t1_id =null) then stop(37892493,'a message'); ) Error --- Auto Commit: On, SQL Mode: Oracle, Isolation Leve