Hi,

I've written a stored procedure with the following sql statements

a) insert a row in table a
b) update a row in table b
c) insert a row in error table
d) select query to list the number of records in the error table

All the above statements are in a single stored procedure.

Can i use query.list() ? Will it does all the inserts, updates and returns the list properly?

I think we cannot use query.executeUpdate() as it returns only number of rows updated or inserted at last sql statement.

Thanks in advance,
Kathir

Can anyone please let me know the comments on this?

Thanks in advance,
Kathir