CREATE PROCEDURE insert_customer (
IN cust_number INTEGER,
IN cust_name CHAR(20)
) BEGIN
SQLIStatement insert_cust = new SQLIStatement (
"INSERT INTO customer VALUES (?,?) ");
insert_cust.setParam (1, cust_number);
insert_cust.setParam (2, cust_name);
insert_cust.execute ();
END