Re: QUESTION: raise_application_error results in ORA-00604...?

From: vc <boston103_at_hotmail.com>
Date: 25 May 2006 14:01:23 -0700
Message-ID: <1148590883.731288.272260@j73g2000cwa.googlegroups.com>

BD wrote:
> >You need to get rid both of the commit and the EXCEPTION clause.
>
> umm... I have to disagree, simply based on the evidence. I removed the
> commit and I still get the 00604.

It's not a matter of opinion but rather of fact especially if you bother to read the relevant Oracle manual.

When you remove the commit, your error would be coming from raise, sort of obvious, no ?

>
> As well, the 06512 error points to the line in the trigger that calls
> raise_application_error. I have no indication that the commit is
> contributing to the additional error messages at all.

See above. Received on Thu May 25 2006 - 16:01:23 CDT