SqlServer到oracle同步数据update触发器

USE [FenHotel]
GO
/****** Object:  Trigger [dbo].[order_update_tigger]    Script Date: 08/23/2019 15:16:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,huQk>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER TRIGGER [dbo].[order_update_tigger]
   ON [dbo].[T_HotelOrder]
   AFTER UPDATE
AS 
BEGIN

    declare @order_state int;
	declare @order_id varchar(20);

			select	@order_id=order_id,@order_state=order_state from inserted;
		
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	--SET NOCOUNT ON;
SET XACT_ABORT on UPDATE OPENQUERY (ORACLE,'SELECT ORDER_ID,ORDER_STATE FROM FN_TICKET.HT_ORDER') SET ORDER_STATE=@order_state where ORDER_ID=@order_id
   
END