Re: Q:Debug Trigger or where dbms_output.putline

Ralf Bender wrote:

> Hi
>
> is there someone who can tell a good way to debug a trigger? And how or
> where can I select the last informations from writing with
> dbms_output.putline?
>
> Thx for helping
>
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

It is impossible to help you given the ambiguity with which you posted.

What version and edition of Oracle?
What kind of trigger? table trigger? statement or row? instead of? DDL? system?
How you typed SHOW ERR after compilation to see the specific errors and the line numbers?
What is the problem?

I would suggest you repost your question and this time provide enough information for someone to help you and include the code itself.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)