Re: raise_application_error with Triggers

[Rishaal Jadoo <rischalj_at_dp.new.iscorltd.co.za>]
|
| ERROR at line 1:
| ORA-20000: Invalid data {Which seems correct}

(your exception)

| ORA-06512: at <Trigger Name>, line 9 {Why does it do this ?}

this happens because the trigger raises an exception that isn't handled anywhere.

| ORA-04088: error during execution of trigger <Trigger Name> {Why does it
| do this ?}

general error message that indicates runtime error during execution of the trigger code. same reason as the former error: because the exception is not being handled.

-Bjørn
--

 Bjørn Borud <borud_at_guardian.no>       | "The Net interprets censorship 
 <URL:http://www.pvv.unit.no/~borud/>  | as damage and routes around it."
 UNIX person, one of "them"            |         - John Gilmore