Re: DBMS_OUTPUT and triggers

A copy of this was sent to kjohnson29_at_my-dejanews.com (if that email address didn't require changing) On Tue, 29 Sep 1998 21:27:11 GMT, you 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:

SQL> set serveroutput on

before doing the insert. that will enable the dbms_output package and tell sqlplus to print out the results...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.