Re: Passing %rowtype to stored proc from trigger

I've never tried it, but you should be able to declare a record type in the header of the procedure you will be passing the parameter to. Then you could create two variables of this type in the trigger, populate the fields, then pass them to the proc.

It's not as neat as what you where trying to do, but I believe it should work.

"jeda" <jedaworks_at_dccnet.com> wrote in message news:tahr8j53v7in75_at_corp.supernews.com...

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 - 10:17:19 CST