DBMS_OUTPUT and triggers
kjohn...@my-dejanews.com
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
Thomas Kyte
(if that email address didn't require changing)
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
tk...@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.
Nuno Guerreiro
>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