Re: Oracle errors not logging to alert log

In article <942amj$9rj$1_at_nnrp1.deja.com>,   Ed Stevens <ed.stevens_at_home.com> wrote:
> Subject: Oracle errors not logging to alert log.
>
> Platform: Oracle 8.0.5.1.1 on NT 4, sp6
>
> Why would an Oracle error reported by an application not show up in
 the
> alert log?
>
> We just spent the better part of the afternoon chasing down an
> ORA-02292. One of the first things I tried to do when it was reported
> by the application programmer was to take a look at the alert log,
> hoping to be pointed to a trace file where I could get my hands on the
> offending SQL statement. But there was no entry in the alert log, and
> there were no trace files generated in the last several days. Does
> anyone have an explanation for the lack of log and trace entries?
>
> (The 2292 itself was obviously a problem in the application code,
 which
> leaves us wondering why it didn't manifest itself earlier, but that's
> another question for another day . . . .)
>
> --
> - Ed Stevens
>
> Sent via Deja.com
> http://www.deja.com/
>

I believe you hit upon the answer yourself. This is an application (data integrity) error, not an Oracle error. I believe Oracle only logs errors that indicate a problem with the Oracle Software is not functioning as expected. In this case, Oracle acted as expected. It did not allow you to delete a parent record when a child record existed.

HTH,
Patrick

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 16 2001 - 15:29:16 CST