create or replace
TRIGGER trig_tbluser1
after INSERT OR UPDATE OR DELETE ON TBLUSERPREFERENCE1
FOR each ROW
BEGIN
  IF     inserting THEN 
    INSERT INTO tbluser@hslink
        
        VALUES
        (
        :NEW.userid,:NEW.password,:NEW.username
        );
       
  ELSIF  updating  THEN NULL;
  ELSIF  deleting  THEN NULL;
END IF;
END;

SQL> Insert into TBLUSERPREFERENCE1 (USERID,PASSWORD,USERNAME) values ('123','abcd','bceef');
Insert into TBLUSERPREFERENCE1 (USERID,PASSWORD,USERNAME) values ('123','abcd','bceef')
            *
ERROR at line 1:
ORA-02047: cannot join the distributed transaction in progress
ORA-06512: at "IRIS.TRIG_TBLUSER1", line 3
ORA-04088: error during execution of trigger 'IRIS.TRIG_TBLUSER1'

create or replace
TRIGGER trig_tbluser1
after INSERT OR UPDATE OR DELETE ON TBLUSERPREFERENCE1
FOR each ROW
DECLARE
 PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
  IF     inserting THEN 
    INSERT INTO tbluser@hslink
        
        VALUES
        (
        :NEW.userid,:NEW.password,:NEW.username
        );
       
  ELSIF  updating  THEN NULL;
  ELSIF  deleting  THEN NULL;
END IF;
commit;
END;

DECLARE c NUMBER; n NUMBER;
BEGIN
  c := DBMS_HS_PASSTHROUGH.OPEN_CURSOR@odbc;
  DBMS_HS_PASSTHROUGH.PARSE@odbc(c,'insert into insert_performance_test values
    ( 1, ''This is data insert test 1''),
    ( 2, ''This is data insert test 2''),
    ( 3, ''This is data insert test 3'')');
  n := DBMS_HS_PASSTHROUGH.EXECUTE_NON_QUERY@odbc (c);
  DBMS_HS_PASSTHROUGH.CLOSE_CURSOR@odbc(c);
END;
/