Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: OK Gurus - one to test you re Triggers
In article <37B970EF.B05F76E4_at_spamme.ed.ac.uk>, Fraser Boswell
<Fraser.Boswell_at_spamme.ed.ac.uk> writes
>Sorry if this doesnt make sense to you, I havent quite got it myself.
>Say I have a cursor which holds all the fieldnames and I load the
>fieldname into a variable called colname.
>in a For Cursor Loop I want to reference each column from it's name in
>the colname
>So in the After Update query I want to write:
> IF :NEW.colname != :OLD.colname THEN -- field has been updated
> --etc
> END IF;
>except :NEW.colname gives me a bad bind variable error.
>How do you get round this. Dynamic SQL?
Sounds like it... although probably simpler and more obvious to just have lots of IF..END IFs.
Andy
--
Andy Hardy. PGP key available on request