database a; 
select * from table(set{ 1 }) into temp t12345 with no log; 
database b; 
select * from t12345; 
drop table t12345;

Database selected.
 1  row(s) retrieved into temp table.
Database closed.

Database selected.
unnamed_col_1 
             1 
 1  row(s) retrieved.

Table dropped.

Database closed.

database a; 
CREATE PROCEDURE AA(
  select * from table(set{ 1 }) into temp t12345 with no log; 
  EXECUTE PROCDURE BB();
END PROCEDURE;

EXECUTE PROCEDURE AA();

database b; 
CREATE PROCEDURE BB(
  BEGIN
    ON EXCEPTION IN (- 206 ) END EXCEPTION WITH RESUME;
    drop table t12345;
    -- Вот здесь он падает, судя по трейсу. Хотя может и строчкой выше
    select * from table(set{ 1 }) into temp t12345 with no log; 
  END
END PROCEDURE;

database b; 
CREATE PROCEDURE BB()
  select * from table(set{1}) into temp t12345 with no log;
END PROCEDURE;

database a;
CREATE PROCEDURE AA()
  EXECUTE PROCedure b:bb();
END PROCEDURE;

database a;
EXECUTE PROCEDURE AA();

database a;
EXECUTE PROCedure b:bb();

-- Создание объектов
DATABASE A;

CREATE PROCEDURE AA()
  SELECT *
    FROM TABLE(SET{ 1 })
    INTO TEMP tmp_drop_me_please
    WITH NO LOG;
END PROCEDURE;

DATABASE B;

CREATE PROCEDURE BB()
  EXECUTE PROCEDURE A:AA();
END PROCEDURE;

-- Проблема (1-й вариант)
DATABASE A;
EXECUTE PROCEDURE B:BB();

-- Проблема (2-й вариант)
DATABASE B;
EXECUTE PROCEDURE A:AA();

-- Удаление объектов
DATABASE A;
DROP PROCEDURE AA;

DATABASE B;
DROP PROCEDURE BB;