读书人

Oracle过程有关问题高手赐教!解决马

发布时间: 2012-01-31 21:28:41 作者: rapoo

Oracle过程问题,高手赐教!在线等,解决马上结!
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO


ALTER PROCEDURE usp_SystemInitialize
( @InitPassword nvarchar(20) )
AS

SET NOCOUNT ON

IF @InitPassword <> 'ePowerHRM ' RETURN 1

--ALTER TABLE CI_LIST DISABLE TRIGGER ALL


TRUNCATE TABLE SYST_USELOG


DELETE SYST_OPERATOR WHERE F_OPERATORID <> 'SYSTEM '

--ALTER TABLE CI_LIST ENABLE TRIGGER ALL


RETURN 0

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

这是MSSQL的过程,我现在要迁移到Oracle,这是我迁移的代码,有问题,高手赐教!

Create Or Replace Procedure Usp_Systeminitialize(Initpassword Nvarchar2) As
Begin
Exit When Initpassword <> 'ePowerHRM ';
Delete Table Syst_Uselog;
Delete Syst_Operator Where f_Operatorid <> 'SYSTEM ';
End Usp_Systeminitialize;

[解决办法]
Create Or Replace Procedure Usp_Systeminitialize(Initpassword in Nvarchar2) As
Begin
if Initpassword <> 'ePowerHRM ' then
return;
end if
TRUNCATE Syst_Uselog;
Delete Syst_Operator Where f_Operatorid <> 'SYSTEM ';
End Usp_Systeminitialize;

读书人网 >oracle

热点推荐