Dear DBA Gurus, How to have a database trigger initiate a 4GL such as Java - or a way for PL/SQl to issue the necessary PUT commands to the queues? Any help would be appreciated. I found a workaround for a similar kind of situation in www.orafans.com. The following is the workaround: Call a pl/sql procedure in the trigger. In this database procedure pack the arguements in a database pipe using standard oracle dbms_pipe package syntax of pack and send. write a pro*c program to read this pipe and unpack the arguements and do the neccessary processing. Has anybody done this before? If so, could you tell me how to do this? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K 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).
