Re: Advance Oracle Trigger Writing Advice

Hello Hanna

Why do not write the data that you want to output to your own table. Give everyone insert permission and the trigger will write the data. Later you can query it and see the output.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, June 17, 2002 8:48 PM

Yup,

But the problem is getting it to output in a session other then the one causeing the trigger to fire (manual inserts wont cause the error for some reason - only when the sql is applied via my replication product). Since I cannot tell what circumstance causes the error, then even a manual insert won't necessary cause it)

Thanks ,

Hannah

> -----Original Message-----
> From: root_at_fatcity.com_at_SUNGARD On Behalf Of Jared.Still_at_radisys.com
> Sent: Monday, June 17, 2002 2:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Advance Oracle Trigger Writing Advice
>
> > I was just wondering if you knew that you can
> > use DBMS_OUTPUT in a trigger
>
> Surprisingly, the answer is yes. Have you tried it?
>
> Jared
>
>
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: johanna.doran_at_sungard.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).