Re: Pass different # of parameters to a procedure?

Hi steve,

    what you could is pass the parameters by name i.e. execute rocedure( param1 => val1 etc) and then have default values defined for each parameter. The only change you would have to make would be to the update statement. suppose the defult value for each parameter was 'nochange'. Your update statement could then read sumething like this

update table
set col1= decode(param1,'nochange',col1,param1), col2 = decode(param2,'nochange',col2,param2) etc

HTH Conan Received on Fri Oct 13 2000 - 03:08:26 CDT