Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_output in trigger
Holger Spangardt <pr05_at_padersoft.unitrade.com> wrote in article
<36371313.A17480A4_at_padersoft.unitrade.com>...
> I need some debugging information for programming a trigger,
> but dbms_output.puline('...') doesn't seem to work or the info
> is send to nirvana. I can't find or see any output.
> Is there a way to make things work?
> (Where has the "serveroutput" to be set?)
Use set serveroutput on in SQLplus session, and perform there the
desired actions for trigger debugging.
But it's better to use dbms_pipe instead.
---
Alexander I.Doroshko, aid_at_grant.kharkov.ua
>
Received on Thu Oct 29 1998 - 03:32:52 CST