Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_output in trigger

Re: dbms_output in trigger

From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 29 Oct 1998 09:32:52 GMT
Message-ID: <01be031f$1134e020$190114c1@sister.grant.UUCP>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US