var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I'm trying to use transactions in my stored procedure without sucess.
I'm trying. It's complile, but not work when I call this procedure inside other procedure.
CREATE PROCEDURE xx (p_item char(15),p_versao integer) RETURNS INTEGER
DEFINE v_erro integer;
on exception set v_erro
end exception with resume
delete from x;
all operations within a single or chain of stored procedures are performed within an implicit transaction. If an exception occurs in the stored procedure thats called from another stored procedure actions of both procedures are rolled back.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors