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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).