Re: DBMS_OUTPUT and triggers

From: Nuno Guerreiro <nuno-v-guerreiro_at_invalid.telecom.pt>
Date: 1998/09/30
Message-ID: <3611f457.1377699627_at_news.telecom.pt>#1/1


On Tue, 29 Sep 1998 21:27:11 GMT, kjohnson29_at_my-dejanews.com wrote:

>Is there a way to see the output generated by DBMS_OUTPUT call within a
>trigger? I am in SQL*Plus calling a SQL script that performs an insert into a
>table. There is a trigger on this table that *is* firing but I can't see the
>output on my screen. Is there something that I need to SET to see this?
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

Issue the following command from SQL*Plus before inserting the row:

SET SERVEROUTPUT ON Good luck,

Nuno Guerreiro

As I don't normally appreciate unsolicited commercial e-mail (widely known as SPAM), I encoded my e-mail address. If you want to reply by e-mail, please remove the text added to fool spam software

"The art of arts, the glory of expression and the sunshine that lights the light of letters  is simplicity"

                                                        Walt Whitman Received on Wed Sep 30 1998 - 00:00:00 CEST

Original text of this message