Re: Can result sets be returned from a trigger?
From: Mark Malakanov <markmal_at_home.com>
Date: 2000/05/11
Message-ID: <goHS4.2231$xa.59306_at_news1.rdc1.on.wave.home.com>#1/1
Date: 2000/05/11
Message-ID: <goHS4.2231$xa.59306_at_news1.rdc1.on.wave.home.com>#1/1
One DML statement can fire many triggers different and even the same type,
even more - all of them for each rows!
How will you receive return from every?
Answer. No. Its impossible.
But you can "pump in" whatewer you want into named pipe (see dbms_pipe) and
pump out from pipe after your DML finished in application.
-- Mark Malakanov Oracle DBA "Brad Lotsberg" <lotsberg_at_willowglen.ab.ca> ???????/???????? ? ???????? ?????????: news:391B1DCC.43E63981_at_willowglen.ab.ca...Received on Thu May 11 2000 - 00:00:00 CEST
> I know that a PL/SQL function can return a result set via a cursor
> variable, but can a trigger return a result set to whatever application
> executed the SQL statement that fired the trigger? I can't find any
> reference to this ability in the documentation, and the RETURN statement
> doesn't seem to work in a trigger.
>
> I am using the OCI on Oracle 8i for Solaris 7.
>
> Thanks for any responses,
>
> Brad Lotsberg, EET.
>
>