ORA-24315: illegal attribute type

SQL> exec p
BEGIN p; END;

*
ERROR at line 1:
ORA-02055: distributed update operation failed; rollback required
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "TEST2.TEST2_TAB_BIR", line 2
ORA-04088: error during execution of trigger 'TEST2.TEST2_TAB_BIR'
ORA-02063: preceding 3 lines from TEST2
ORA-06512: at "TEST1.P", line 4
ORA-06512: at line 1

SQL> select sysdate from dual;
select sysdate from dual
                    *
ERROR at line 1:
ORA-02067: transaction or savepoint rollback required

SQL> select sysdate from dual;
select sysdate from dual
                    *
ERROR at line 1:
ORA-02067: transaction or savepoint rollback required


SQL> conn test1/test1@xe
ERROR:
ORA-02067: transaction or savepoint rollback required


ERROR:
ORA-24315: illegal attribute type