how to insert data in table (stored proc) without taking all the values as parameters

[Faheem_Ahmed]

Hi!

I am trying to insert values in a table by using callablestatement. but the table has more than 80 fields. is the only way to pass all the fields values as parameters? as having more 80+ values as parameters to the procedure will not be a good idea. and i may not be inserting all the values everytime. one time i may insert only 20 values in the table and next time maybe 50..

Is there any way to cal the callable statement without sending all the values as parameters..Pls help..


Thanks in advance
Faheem