Hi Folks I have a trigerr that fires before a table is
updated .
I want a way of passing the new parameters that have
been updated to a procedure. This procedure compiles
weel but does not return the right values for new
values on THE_TABLE.

Please help

This is what I have

DECLARE
errnum NUMBER;
errmsg VARCHAR2(100);

BEGIN

IF < my coditions> = FALSE THEN

( codes to update THE_TABLE >

pr_update_equip_x_update(:NEW.THE_TABLE.column1,
:NEW.THE_TABLE.column2,
:NEW.THE_TABLE.column3,
:NEW.THE_TABLE.column4)

END IF;


exception
when others then
errnum:= 999;
errmsg:= 'AN Error occurred'
end;


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
Oracle LazyDBA home page