连续创建多个Oracle触发器失败，单个创建才成功的解决方法

错误截图如下：

这种创建是失败的，因为触发器需要先编译，每创建一个触发器，需要以“/”结束，然后才能执行下一个。

正确的做法应该是这样的;

---<span style="color: #800080">1</span><span style="color: #000000">.应用信息
drop table app_info cascade constraints;
create table APP_INFO
(
  id      NUMBER(</span><span style="color: #800080">9</span>)   not <span style="color: #0000ff">null</span><span style="color: #000000">,
  appid    VARCHAR2(</span><span style="color: #800080">255</span>)        <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  appkey    VARCHAR2(</span><span style="color: #800080">255</span>)       <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  md5_key          VARCHAR2(</span><span style="color: #800080">255</span>)    <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  aes_key    VARCHAR2(</span><span style="color: #800080">255</span>)      <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  permission    VARCHAR2(</span><span style="color: #800080">3000</span>)     <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  email    VARCHAR2(</span><span style="color: #800080">255</span>)       <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  password    VARCHAR2(</span><span style="color: #800080">255</span>)      <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  ras_public_key     VARCHAR2(</span><span style="color: #800080">255</span>)  <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  constraint APP_INFO primary key (id)
);
drop sequence app_info_id;
create sequence app_info_id
increment by </span><span style="color: #800080">1</span><span style="color: #000000">
start with </span><span style="color: #800080">1</span><span style="color: #000000">
nomaxvalue
nominvalue
nocache;
CREATE OR REPLACE TRIGGER addAppInfo BEFORE INSERT ON App_INFO FOR EACH ROW  
 BEGIN  
    SELECT app_info_id.nextval INTO :</span><span style="color: #0000ff">new</span><span style="color: #000000">.id  FROM dual;  
 END; 
</span>/
---<span style="color: #800080">2</span><span style="color: #000000">.unit信息
drop table unit_info cascade constraints;
create table UNIT_INFO
(
  UNIT_ID        NUMBER(</span><span style="color: #800080">9</span>)  not <span style="color: #0000ff">null</span><span style="color: #000000">,
  USERID          VARCHAR2(</span><span style="color: #800080">255</span>)        <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  UNIT_NAME      VARCHAR2(</span><span style="color: #800080">128</span>)        <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  UNIT_LINKMAN      VARCHAR2(</span><span style="color: #800080">64</span>)    <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  ORGANIZATION_CODE        VARCHAR2(</span><span style="color: #800080">64</span>)     <span style="color: #0000ff">default</span><span style="color: #000000"> NULL,
  constraint UNIT_INFO primary key (UNIT_ID)
);
drop sequence unit_info_id;
create sequence unit_info_id
increment by </span><span style="color: #800080">1</span><span style="color: #000000">
start with </span><span style="color: #800080">1</span><span style="color: #000000">
nomaxvalue
nominvalue
nocache;
CREATE OR REPLACE TRIGGER addUnitInfo BEFORE INSERT ON UNIT_INFO FOR EACH ROW  
 BEGIN  
    SELECT unit_info_id.nextval INTO :</span><span style="color: #0000ff">new</span><span style="color: #000000">.unit_id  FROM dual;  
 END; 
</span>/

 注意：存储过程也是一样的。

连续创建多个Oracle触发器失败，单个创建才成功的解决方法

标签：pid   word   成功   strong   nocache   har   触发器   default   const