CREATE PROCEDURE transfer( :from INTEGER, :to INTEGER, :amount DECIMAL(10,2) BEGIN UPDATE Accounts SET Balance = Balance - :amount WHERE Account_Number = :from; UPDATE Accounts SET Balance = Balance + :amount WHERE Account_Number = :to; END
String definition = "CREATE PROCEDURE transfer(" + . . . + ") BEGIN" + . . . +"END"; stat.execute(definition);