Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Passing %rowtype to stored proc from trigger
I have a stored procedure
Procedure CREATE RECEIPTS ( old in shipmentlines%rowtype, new in
shipmentlines%rowtype)
and want to call it from an afterInsert trigger.
Create trigger fibreTrans receipts after insert on fibretrans
referencing new as new old as old for each row
begin
CREATE RECEIPTS (:old, :new);
end;
But Oracle does not like the syntex. How can I pass the triggers old and new rows to the stored proc?
--Received on Fri Mar 09 2001 - 08:48:09 CST