IF V_COUNT >0 THEN
V_COUNT都没有赋值,怎么能作判断
V_COUNT都没有赋值,怎么能作判断
解决方案 »
- ORACLE数据库中表的序列下一个值比最大值小,这种情况下会提示主键重复,请问为什么会出现这种情况?
- 下面这四个事务用两段加锁协议之后会造成死锁吗?
- oracle查询,有建表语句、和测试数据,请帮忙看看
- 帮忙转换个简单的sql语句,在线等
- 多台数据库的数据同步问题,急
- 把dataset中的数据导入到oracle数据库的问题
- ORA-01795 maximum number of expressions in a list is 1000
- 急!!!如何排序?
- 开新贴感谢给我原代码的朋友dihai2000
- 请各位指点迷津
- 开贴讨论一个Fetch .. into 问题!!!
- 请教如何显示oracle9i中自定义包的源代码
CREATE OR REPLACE TRIGGER "SBDBA"."TRI_TA_ZGGRZHSZMX_COMZHHRJE" AFTER INSERT OR DELETE OR UPDATE OF "CZY", "DFJE", "JFJE", "SHBZHM" ON "TA_ZGGRZHSZMX" FOR EACH ROW Begin
Declare
V_HRJE NUMBER(18,2);
V_COUNT INTEGER;
Begin
SELECT COUNT(*) INTO V_COUNT FROM TA_ZGGRZHSZMX WHERE SHBZHM=:NEW.SHBZHM;
IF V_COUNT >0 THEN
Select
SUM(
DECODE(
TA_ZGGRZHSZMX.CZY,
'触发操作',0,
'异地报销', 0,
'特病报销', 0,TA_ZGGRZHSZMX.DFJE - TA_ZGGRZHSZMX.JFJE)) INTO V_HRJE
FROM TA_ZGGRZHSZMX
Where shbzhm=:NEW.SHBZHM;
END IF;
RETURN;
UPDATE TA_GZJBXX SET HRZE=V_HRJE WHERE SHBZHM=:NEW.SHBZHM ;
IF :NEW.SHBZHM <>:OLD.SHBZHM THEN
Select
sum(
DECODE(
TA_ZGGRZHSZMX.CZY,
'触发操作',0,
'异地报销', 0,
'特病报销', 0,TA_ZGGRZHSZMX.DFJE - TA_ZGGRZHSZMX.JFJE)) INTO V_HRJE
FROM TA_ZGGRZHSZMX
Where shbzhm=:OLD.SHBZHM;
UPDATE TA_GZJBXX SET HRZE=V_HRJE WHERE SHBZHM=:OLD.SHBZHM ;
END IF;
End ; end;