Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing :NEW or :OLD as record to a procedure or function from trigger

330483Jan 27 2004 — edited Feb 5 2004
Is 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;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2004
Added on Jan 27 2004
5 comments
1,893 views