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