CREATE PROCEDURE sis_makeNULL()
BEGIN SQLIStatement insert_sfns1 = new SQLIStatement ("INSERT INTO sfns (fld_ref,small_fld,int_fld,doub_fld,char_fld,vchar_fld) values (?,?,?,?,?,?)" ); insert_sfns1.setParam(1,new Integer(66)); insert_sfns1.makeNULL(2); insert_sfns1.makeNULL(3); insert_sfns1.makeNULL(4); insert_sfns1.makeNULL(5); insert_sfns1.makeNULL(6); insert_sfns1.execute(); END |