请教：存储过程中创建临时表问题

ilsac

我有两个存储过程A、B，A调用B，B中建立了临时表，A中有提交和回滚，
执行A，出错：
There was a transaction active when exiting the stored procedure 'A.The temporary table '#aaa'
was dropped in this transaction either explicitly or implicitly. This transaction has been aborted to
prevent database corruption.

存储过程基本如下结构：
create procedure A
as
declare
--定义变量

begin
    BEGIN TRANSACTION  TRAN_A
    execute B
    IF @@ERROR<>0 OR @L_ERRCODE <> 0   BEGIN         
      GOTO FAILED         
    END
    COMMIT TRAN_A
FAILED:         
   ROLLBACK TRAN_A
end;


create procedure B
as
--定义变量
create table #aaa
(
)
begin

return
end;
请问问题出现在哪里，应如何修改，谢谢！