CREATE OR REPLACE PROCEDURE sequence_no(pref IN char, lotsize IN integer, newseqno OUT integer)
AS
seqnew integer:=0;
BEGIN
SELECT SEQ_NO INTO newseqno from SEQUENCENUMBERS WHERE PREFIX = pref;
seqnew:= newseqno + lotsize;
UPDATE SEQUENCENUMBERS SET SEQ_NO=seqnew WHERE PREFIX = pref;
END sequence_no;
/

 Statement * seqst;

seqst = conn->createStatement();
seqst->setAutoCommit(true);
int seqno = 0;
seqst->setSQL("BEGIN sequence_no(:1, :2,:3); END:");
int quantity;
int sq = 100;
seqst->setString(1, "orders");
seqst->setInt(2,sq);
seqst->registerOutParam(3,OCCIINT, sizeof(quantity));
seqst->executeUpdate();