用powerdesigner生成oracle的触发器，报触发器无效且未通过重新验证

我是用powerdesigner生成触发器的，头文件已经删除。查看具体错误信息时显示：
TRIGGER WEN.COMPOUNDUPDATETRIGGER_HRM_USER 编译错误

错误：PLS-00103: 出现符号 "/"在需要下列之一时：
function pragma
procedure subtype type
current cursor delete
exists prior before after instead
行：8
文本：NULL;

生成的触发器脚本如下：

CREATE OR REPLACE TRIGGER COMPOUNDDELETETRIGGER_HRM_DEPT
FOR DELETE ON HRM_DEPT COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE OR REPLACE TRIGGER COMPOUNDINSERTTRIGGER_HRM_DEPT
FOR INSERT ON HRM_DEPT COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE OR REPLACE TRIGGER COMPOUNDUPDATETRIGGER_HRM_DEPT
FOR UPDATE ON HRM_DEPT COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE TRIGGER TIB_HRM_DEPT BEFORE INSERT
ON HRM_DEPT FOR EACH ROW
DECLARE
    INTEGRITY_ERROR  EXCEPTION;
    ERRNO            INTEGER;
    ERRMSG           CHAR(200);
    DUMMY            INTEGER;
    FOUND            BOOLEAN;

BEGIN
    --  COLUMN "ID" USES SEQUENCE SEQUENCE_1
    SELECT SEQUENCE_1.NEXTVAL INTO :NEW.ID FROM DUAL;

--  ERRORS HANDLING
EXCEPTION
    WHEN INTEGRITY_ERROR THEN
       RAISE_APPLICATION_ERROR(ERRNO, ERRMSG);
END;
/


CREATE OR REPLACE TRIGGER COMPOUNDDELETETRIGGER_HRM_DOCU
FOR DELETE ON HRM_DOCUMENT COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE OR REPLACE TRIGGER COMPOUNDINSERTTRIGGER_HRM_DOCU
FOR INSERT ON HRM_DOCUMENT COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE OR REPLACE TRIGGER COMPOUNDUPDATETRIGGER_HRM_DOCU
FOR UPDATE ON HRM_DOCUMENT COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE TRIGGER TIB_HRM_DOCUMENT BEFORE INSERT
ON HRM_DOCUMENT FOR EACH ROW
DECLARE
    INTEGRITY_ERROR  EXCEPTION;
    ERRNO            INTEGER;
    ERRMSG           CHAR(200);
    DUMMY            INTEGER;
    FOUND            BOOLEAN;

BEGIN
    --  COLUMN "ID" USES SEQUENCE SEQUENCE_1
    SELECT SEQUENCE_1.NEXTVAL INTO :NEW.ID FROM DUAL;

--  ERRORS HANDLING
EXCEPTION
    WHEN INTEGRITY_ERROR THEN
       RAISE_APPLICATION_ERROR(ERRNO, ERRMSG);
END;
/


CREATE OR REPLACE TRIGGER COMPOUNDDELETETRIGGER_HRM_EMPL
FOR DELETE ON HRM_EMPLOYEE COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE OR REPLACE TRIGGER COMPOUNDINSERTTRIGGER_HRM_EMPL
FOR INSERT ON HRM_EMPLOYEE COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE OR REPLACE TRIGGER COMPOUNDUPDATETRIGGER_HRM_EMPL
FOR UPDATE ON HRM_EMPLOYEE COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE TRIGGER TIB_HRM_EMPLOYEE BEFORE INSERT
ON HRM_EMPLOYEE FOR EACH ROW
DECLARE
    INTEGRITY_ERROR  EXCEPTION;
    ERRNO            INTEGER;
    ERRMSG           CHAR(200);
    DUMMY            INTEGER;
    FOUND            BOOLEAN;

BEGIN
    --  COLUMN "ID" USES SEQUENCE SEQUENCE_1
    SELECT SEQUENCE_1.NEXTVAL INTO :NEW.ID FROM DUAL;

--  ERRORS HANDLING
EXCEPTION
    WHEN INTEGRITY_ERROR THEN
       RAISE_APPLICATION_ERROR(ERRNO, ERRMSG);
END;
/


CREATE OR REPLACE TRIGGER COMPOUNDDELETETRIGGER_HRM_JOB
FOR DELETE ON HRM_JOB COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE OR REPLACE TRIGGER COMPOUNDINSERTTRIGGER_HRM_JOB
FOR INSERT ON HRM_JOB COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE OR REPLACE TRIGGER COMPOUNDUPDATETRIGGER_HRM_JOB
FOR UPDATE ON HRM_JOB COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE TRIGGER TIB_HRM_JOB BEFORE INSERT
ON HRM_JOB FOR EACH ROW
DECLARE
    INTEGRITY_ERROR  EXCEPTION;
    ERRNO            INTEGER;
    ERRMSG           CHAR(200);
    DUMMY            INTEGER;
    FOUND            BOOLEAN;

BEGIN
    --  COLUMN "ID" USES SEQUENCE SEQUENCE_1
    SELECT SEQUENCE_1.NEXTVAL INTO :NEW.ID FROM DUAL;

--  ERRORS HANDLING
EXCEPTION
    WHEN INTEGRITY_ERROR THEN
       RAISE_APPLICATION_ERROR(ERRNO, ERRMSG);
END;
/


CREATE OR REPLACE TRIGGER COMPOUNDDELETETRIGGER_HRM_NOTI
FOR DELETE ON HRM_NOTICE COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE OR REPLACE TRIGGER COMPOUNDINSERTTRIGGER_HRM_NOTI
FOR INSERT ON HRM_NOTICE COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE OR REPLACE TRIGGER COMPOUNDUPDATETRIGGER_HRM_NOTI
FOR UPDATE ON HRM_NOTICE COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


CREATE TRIGGER TIB_HRM_NOTICE BEFORE INSERT
ON HRM_NOTICE FOR EACH ROW
DECLARE
    INTEGRITY_ERROR  EXCEPTION;
    ERRNO            INTEGER;
    ERRMSG           CHAR(200);
    DUMMY            INTEGER;
    FOUND            BOOLEAN;

BEGIN
    --  COLUMN "ID" USES SEQUENCE SEQUENCE_1
    SELECT SEQUENCE_1.NEXTVAL INTO :NEW.ID FROM DUAL;

--  ERRORS HANDLING
EXCEPTION
    WHEN INTEGRITY_ERROR THEN
       RAISE_APPLICATION_ERROR(ERRNO, ERRMSG);
END;
/


CREATE OR REPLACE TRIGGER COMPOUNDDELETETRIGGER_HRM_USER
FOR DELETE ON HRM_USER COMPOUND TRIGGER
// DECLARATION
// BODY
  BEFORE STATEMENT IS
  BEGIN
     NULL;
  END BEFORE STATEMENT;

  BEFORE EACH ROW IS
  BEGIN
     NULL;
  END BEFORE EACH ROW;

  AFTER EACH ROW IS
  BEGIN
     NULL;
  END AFTER EACH ROW;

  AFTER STATEMENT IS
  BEGIN
     NULL;
  END AFTER STATEMENT;

END
/


/

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
十口文 2016-08-07 15:41
关注
我已经解决，创建时勾多了几个选项

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

powerdesigner生成的触发器 错误求解 oracle
2015-08-04 16:07

回答 1 已采纳 http://bbs.csdn.net/topics/60451422
使用powerdesigner生成sql脚本问题
2016-10-24 13:33

回答 4 已采纳把go去掉？ ![图片说明](https://img-ask.csdn.net/upload/201610/25/1477382824_714148.jpg)
【新兵营】PowerDesigner中如何生成的Ldm只有主外键
2016-02-17 09:03

回答 2 已采纳用的比较少：看看这个文章吧！http://blog.csdn.net/zhang6622056/article/details/8136602
ORA -04098 触发器无效且未通过重新验证
2018-12-22 20:14

weixin_34284188的博客 ORACLE 菜鸟，犯了一个低级错误，用PowerDesigner的SQL Preview创建表的时候没有创建sequence，导致新增数据报此错误，折腾半天才反应过来！于是打开PowerDesigner，找到主键一列->属性->sequence 属性-...
powerdesigner生成数据库语句时出错
2010-01-15 12:26

回答 3 已采纳你的答案在这 http://topic.csdn.net/u/20070404/16/42a922e5-2560-482e-a1b7-70687fb8ae7f.html
怎么使用powerdesigner怎么设置多列非聚集索引
2017-05-24 09:22

回答 2 已采纳如下图，当 **不勾选** Cluster时，建立的即为非聚集索引。 ![图片说明](https://img-ask.csdn.net/upload/201705/24/1495619838_4
powerdesigner表中sql字体太小了，怎么放大 java sql
2022-04-12 09:57

回答 3 已采纳 tools —> general options —> fonts --> code editor ,选择字体样式及大小即可。https://blog.csdn.net/xjx891
Powerdesigner添加Oracle数据库触发器模板
2019-01-15 14:33

路很宽的博客使用方法如下:(环境Oracle,触发器使字段能自增) 1.右键点根目录-&gt;new-&gt;Trigger items 2.在properties中选Definition,填入如下代码 create or replace trigger Trigger_%TABLE% before ...
powerDesigner如何选择概念模型和物理模型？ oracle
2019-11-19 09:04

回答 1 已采纳 **如果把创建数据库模型比喻成建筑一座楼房，工程师依用户的需求用E-R图等对信息和数据进行“画图”，让客户确认结果，这个建筑前“蓝图”就是用概念模型，它是面向用户的。客户确定后，依照“蓝图”“开始施工
powerdesigner16.5安装出问题 java
2022-12-23 00:05

回答 1 已采纳选择第二个repair，不管有没装过，选这个不会有错。
powerDesigner的update model from database 没有注释! 数据库
2017-04-12 10:32

回答 2 已采纳无满意答案,自己终结帖子~
Oracle触发器未找到且,oracle觸發器導致的hibernate違反完整性約束, (*) - 未找到父項關鍵字...
2021-05-05 09:50

zhongxiao.yzx的博客在做項目的時候，出現了hibernate違反完整性約束, (*) - 未找到父項關鍵字，這個錯誤其實不難理解。很多時候我們只有是什么原因導致的。但是，不知道具體原因和解決的方法。當然出現了這個問題的時候，改來改去好像...
PowerDesigner表设计&Oracle数据库的使用
2023-02-22 23:32

sima-kking的博客，第二行是2，依此类推，这个伪字段可以用于限制查询返回的总行数，且rownum不能以任何表的名称作为前缀。如果安装安装版本，需要手动创建本地服务。安装时需要输入system的密码，oracle的密码是无法破解的，忘记了...
powerdesigner创建oracle_数据库表,设置表主键列为自动增长
2012-02-16 16:26

### PowerDesigner 创建 Oracle 数据库表并设置主键...以上步骤详细介绍了如何使用PowerDesigner 12.5创建Oracle数据库表，并设置主键列的自动增长功能。这将极大地提高数据库开发的效率，并确保数据的一致性和完整性。
PowerDesigner通过物理数据模型正向生成sql脚本并通过dbms创建表
2019-04-14 01:00

开发者可以自定义生成脚本的格式，比如选择使用Oracle、MySQL、SQL Server等特定数据库的语法，这使得PowerDesigner适用于多种数据库系统。在"使用powerDesigner物理数据模型正向生成sql.xls"这个文件中，可能包含...
没有解决我的问题, 去提问

悬赏问题

¥15 PointNet++的onnx模型只能使用一次
¥20 西南科技大学数字信号处理
¥15 有两个非常“自以为是”烦人的问题急期待大家解决！
¥30 STM32 INMP441无法读取数据
¥15 R语言绘制密度图，一个密度曲线内fill不同颜色如何实现
¥100 求汇川机器人IRCB300控制器和示教器同版本升级固件文件升级包
¥15 用visualstudio2022创建vue项目后无法启动
¥15 x趋于0时tanx-sinx极限可以拆开算吗
¥500 把面具戴到人脸上，请大家贡献智慧，别用大模型回答，大模型的答案没啥用
¥15 任意一个散点图自己下载其js脚本文件并做成独立的案例页面，不要作在线的，要离线状态。

用powerdesigner生成oracle的触发器，报触发器无效且未通过重新验证

1条回答 默认 最新

悬赏问题

1条回答默认最新