powerdesigner生成的sql文件导入oracle产生Warning: Trigger created with compilation errors

qq_35524219 2017-06-12 08:39:56
powerdesigner生成的sql文件导入oracle产生Warning: Trigger created with compilation errors,然后在表中插入数据时会有触发器无效或未通过验证,这是什么原因?
...全文
355 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
小当家e 2017-06-12
  • 打赏
  • 举报
回复
// 你这个符号是注释吗?oracle的注释有单行注释----,多行注释 /* */
qq_35524219 2017-06-12
  • 打赏
  • 举报
回复
create or replace trigger D_m_account_data for delete on M_ACCOUNT_DATA 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 I_m_account_data for insert on M_ACCOUNT_DATA 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 U_m_account_data for update on M_ACCOUNT_DATA 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 / 这个是出异常的sql代码

17,086

社区成员

发帖
与我相关
我的任务
社区描述
Oracle开发相关技术讨论
社区管理员
  • 开发
  • Lucifer三思而后行
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧