ORA-02074: cannot SET SAVEPOINT in a distributed transaction

[gamyers]

Autonomous transaction is a bad idea. It won't see any uncommitted changes from your main transaction, and the commit would only apply to the insert in your autonomous transaction.

If you can't use savepoints, you'll need to actually do the test before the insert, so you can NOT INSERT, rather than INSERT/ROLLBACK.

create or replace procedure insert_into_t
as
myCondition boolean ;
begin
if myCondition then
insert into t values ( 1 );
commit;
end if;
end;