Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Passing :NEW and :OLD from triggers to procedures

Passing :NEW and :OLD from triggers to procedures

From: Jim Jenkinson <jjenkins_at_castle.net>
Date: 1997/02/14
Message-ID: <33046B3A.4CAD@castle.net>#1/1 







Does anyone know if it is possible to pass an entire row from a row
level trigger to a procedure which accepts input parameters of the same
%ROWTYPE as the table in question?



For example, on table TEST, I would like to create an after row trigger
which passes the entire :NEW and :OLD structures to a procedure which
accepts parameters of TEST%ROWTYPE.



Can this be done? Please post a reply or email privately to
JJenkins_at_castle.net
Received on Fri Feb 14 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US