select * from OPENQUERY (QVHKTEST, 'SELECT * FROM QVSYSTEM')

INSERT OPENQUERY (QVHKTEST, 'SELECT     BODY_NO,
                                    MERCHANDISE,
			          MODEL_NAME,
				  LINE_NAME,
				  DATE_ENTRY
			    FROM QVSYSTEM')
values('VNF4619829','3227B002CA','L1068','01','2012/09/26 03:18:11');

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author Name: Phuong Do Minh >
-- Create date: <Create Date: 10/12/2012>
-- Description:	<Description: After data insert into table qvsystem on SQL server
--							  This trigger will fire and insert that data into table qvsystem
--							  On Oracle Server	>
-- =============================================
ALTER TRIGGER [dbo].[TRI_INSERT_QVSYSTEM_AT_ORACLE]
   ON  [dbo].[qvsystem] 
   AFTER  INSERT
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	--SET XACT_ABORT ON;

	  declare @body_no varchar(100);
	  declare @merchandise varchar(100);
	  declare @model_name varchar(100);
	  declare @line_name varchar(100);
	  declare @date_entry varchar(100);
	  ------------------------------
	  -- Lay du lieu cua dong vua moi insert duoc trong bang qvsystem

	  select @body_no=i.body_no from  inserted i;
	  select @merchandise=i.merchandise from  inserted i;
	  select @model_name=i.model_name from  inserted i;
	  select @line_name=i.line_name from  inserted i;
	  select @date_entry=i.date_entry from  inserted i;
	  ---------------------------------
INSERT OPENQUERY (QVHKTEST, 'SELECT     BODY_NO,
                                    MERCHANDISE,
			          MODEL_NAME,
				  LINE_NAME,
				  DATE_ENTRY
			    FROM QVSYSTEM')
VALUES (@body_no,@merchandise,@model_name,@line_name,@date_entry);	  
  

END

OLE DB provider "OraOLEDB.Oracle" for linked server "QVHKTEST" returned message "New transaction cannot enlist in the specified transaction coordinator. ".
Msg 7391, Level 16, State 2, Procedure Insert_data, Line 16
The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "QVHKTEST" was unable to begin a distributed transaction.