Hallo new one,Test it.

-------------------------------------------------
-->> pragma autonomous_transaction
-------------------------------------------------

drop table t;

create table t ( msg varchar2(25) );

create or replace function Autonomous_Insert(Var Varchar2)
return number
is
pragma autonomous_transaction;
begin
insert into t values ( Var );
commit;
return (0);
exception when others then return (1);
end;
-------------------------------------------------

select Autonomous_Insert('Nanu') from dual;
select * from t;