Passing :NEW or :OLD as record to a procedure or function from trigger
330483Jan 27 2004 — edited Feb 5 2004Is there any facility to pass the entire record from a trigger to another procedure or function using :NEW or :OLD instead of mentioning each and every column bound with :NEW or :OLD.
Please respond me immediately as this is urgent.
For example,
CREATE FUNCTION check_function(a my_temp%ROWTYPE, b my_temp%ROWTYPE) RETURN BOOLEAN as
BEGIN
Dbms_Output.put_line('hai');
RETURN TRUE;
END;
create trigger my_trigger
after insert or delete or update
on my_temp
for each row
begin
check_function(:NEW, :OLD)
end;