sybase 转oracle,sybase触发器转成oracle~大家帮忙~解决方法

当前位置:我的异常网» Oracle开发 » sybase触发器转成oracle~大家帮忙~解决方法

sybase触发器转成oracle~大家帮忙~解决方法

www.myexceptions.net  网友分享于：2013-03-13  浏览：17次

sybase触发器转成oracle~~大家帮忙~

sybase触发器如下,现在要移植到oracle~~~

CREATE     TRIGGER     tr_for_u_files     ON     V_Y_KHDA

FOR     INSERT     AS

declare     getUserInfo     cursor     for

select     HH     from     inserted

for     read     only

declare     @user_no     varchar(20)

open     getUserInfo

fetch     getUserInfo     into     @user_no

while     @@sqlstatus     !=     2

begin

if     @@sqlstatus     !=     1

begin

DELETE     FROM     USER_FILES     WHERE     USER_NO     =     @user_no

if     @@error     !=     0

begin

rollback

continue

end

INSERT     INTO     USER_FILES(USER_NO,USER_NAME,ADDRESS,VOLT_LEVEL_CODE,ALL_CAPACITY,CANCEL_DATE,HAVE_ADD_INFO)

SELECT     HH,HM,YDDZ,convert(int,DYDJ),HTRL,XHRQ, "1 "     FROM     inserted     WHERE     HH     =     @user_no

if     @@error     !=     0

rollback     tran

else

commit     tran

end

fetch     getUserInfo     into     @user_no

end

close     getUserInfo

deallocate     cursor     getUserInfo

我转成下面这样,但是有错误~~

CREATE     OR     REPLACE     TRIGGER     tr_for_u_files

文章评论