sqlserver存储过程转换成oracle的，急求帮助，在线等！！！！！谢谢！！！ 50
SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOcreatePROCEDURE[dbo].[sp_update_cms_contract...
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[sp_update_cms_contract_nstc_interface]
AS
declare @errorvariable int
BEGIN
SET XACT_ABORT ON
BEGIN TRY
BEGIN TRAN T1
--更新零售合同信息
delete IF_Contract
insert into IF_Contract
select * from [10.192.68.177].[EsApp].[dbo].[NSTC_IF_Contract_T]
COMMIT TRAN T1
END TRY
BEGIN CATCH
set @errorvariable=@@ERROR
IF @errorvariable<>0
BEGIN
ROLLBACK TRAN T1
RETURN
END
END CATCH
END
这是sqlserver的，想要转为oracle的，该怎么写？我实在是转不对了，各位高手帮帮忙啊，先谢谢您啦！ 展开
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[sp_update_cms_contract_nstc_interface]
AS
declare @errorvariable int
BEGIN
SET XACT_ABORT ON
BEGIN TRY
BEGIN TRAN T1
--更新零售合同信息
delete IF_Contract
insert into IF_Contract
select * from [10.192.68.177].[EsApp].[dbo].[NSTC_IF_Contract_T]
COMMIT TRAN T1
END TRY
BEGIN CATCH
set @errorvariable=@@ERROR
IF @errorvariable<>0
BEGIN
ROLLBACK TRAN T1
RETURN
END
END CATCH
END
这是sqlserver的，想要转为oracle的，该怎么写？我实在是转不对了，各位高手帮帮忙啊，先谢谢您啦！ 展开
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
