Generalized UPDATE procedure

I'd like to use a generalized UPDATE procedure such as this:

procedure genUpd( key varchar2, aCol varchar2, bCol varchar2) is rec rowtype%myTable
begin
 select * into rec where keyCol = key for update;

• update column a if value supplied if aCol is not null then rec.a = aCol;
• update column b if value supplied if bCol is not null then rec.b = bCol; update myTable set (a,b) = (rec.a, rec.b); end;

What are the pros and cons of this method?

Thanks

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 05 1999 - 12:31:04 CDT