Muthu,


[Big snip]

> UPDATE DENOMINATION SET BILLCOUNT = :HUNDRED, FLAG=:FLAG
> WHERE BILLTYPE = 'OBHUNDRED';
> SUSPEND;
> END

[another snip]

>
> EXECUTE PROCEDURE GETDENOMINATIONTOTAL
> RETURNING_VALUES
> (:OPENINGBALANCE,:CASHIN,:CASHOUT,:CLOSINGBALANCE);

You must not execute a procedure that's a selectable one (working with
SUSPEND).
If this is the case you have to SELECT from that procedure.

SELECT * [OR OUTPUTFIELDS] FROM GETDENOMINATIONTOTAL
INTO :OPENINGBALANCE,:CASHIN,:CASHOUT,:CLOSINGBALANCE;

is the way to go.

Luc.