SQL7 and Stored Procedure ISSUE!!!!

[cenwesi]

Can someone explain to me why i have to put commit using sqlca at the end of this stored procedure execution
=======================================================
int mout

DECLARE webrequest PROCEDURE FOR web_request
@code = :cd1,
@code2 = :cd2,
@code3 = :cd3,
@msg = :mesg using sqlca;

EXECUTE webrequest;
FETCH webrequest into :mout;
CLOSE webrequest;

commit using sqlca;

 

[royjimenez]

what are u problem ?

 

[cenwesi]

The server hangs/blocks other users.

 

[royjimenez]

in pb, when u use commands like Update, insert, a transaction begins and we need to do a commit o rollback.

Your SP could be updating information in any table.

is it ?

 

[cenwesi]

yes it is...updating a table