I wrote a trigger and use %rowtype , the problue is I need to put the
column name in a variable
like
Declare
columnname VARCHAR(20);
NOTIFYRULE NOTIFY_RULE%ROWTYPE
begin
columnname='TYPE' /* ONE OF NOTIFY_RULE column*/
SELECT * INTO NOTIFYRULE FROM NOTIFY_RULE WHERE STATUS=:OLD.STATUS;
end;
how can i use this columnname to get the column value form NOTIFYRULE
without use "NOTIFYRULE.TYPE"
