时间:2021-07-01 10:21:17 帮助过:23人阅读
错误截图如下:
这种创建是失败的,因为触发器需要先编译,每创建一个触发器,需要以“/”结束,然后才能执行下一个。
正确的做法应该是这样的;
- ---<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