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...
> 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.
>
>
Received on Thu May 11 2000 - 00:00:00 CDT
