CREATE OR REPLACE TRIGGER EMP_TRIGGER BEFORE
INSERT ON ACTINSTANCEBASIC FOR EACH ROW
when (new.ACTIVITYINSTANCEID is null)
begin
select emp_sequence.nextval into: new.ACTIVITYINSTANCEID from dual;
end;这个触发器哪不对,我编译时报错误。错误:
TRIGGER FINIXWORKFLOW.EMP_TRIGGER 编译错误错误:PLS-00801: 内部错误 [ph2csql_strdef_to_diana:bind]
行:3
文本:when (new.ACTIVITYINSTANCEID is null)错误:PL/SQL: ORA-06544: PL/SQL: 内部错误, 参数: [ph2csql_strdef_to_diana:bind], [], [], [], [], [], [], []
行:5
文本:select emp_sequence.nextval into: new.ACTIVITYINSTANCEID from dual;错误:PL/SQL: SQL Statement ignored
行:5
文本:select emp_sequence.nextval into: new.ACTIVITYINSTANCEID from dual;
INSERT ON ACTINSTANCEBASIC FOR EACH ROW
when (new.ACTIVITYINSTANCEID is null)
begin
select emp_sequence.nextval into: new.ACTIVITYINSTANCEID from dual;
end;这个触发器哪不对,我编译时报错误。错误:
TRIGGER FINIXWORKFLOW.EMP_TRIGGER 编译错误错误:PLS-00801: 内部错误 [ph2csql_strdef_to_diana:bind]
行:3
文本:when (new.ACTIVITYINSTANCEID is null)错误:PL/SQL: ORA-06544: PL/SQL: 内部错误, 参数: [ph2csql_strdef_to_diana:bind], [], [], [], [], [], [], []
行:5
文本:select emp_sequence.nextval into: new.ACTIVITYINSTANCEID from dual;错误:PL/SQL: SQL Statement ignored
行:5
文本:select emp_sequence.nextval into: new.ACTIVITYINSTANCEID from dual;
解决方案 »
- SYSTEM、SYSAUX表空间使用率达到99%,怎么办?
- 安装了oracle 11g client,发现木有dbca,杯具啊
- sql语句执行速度特别慢的问题
- 关于ORACLE多个实例的启动与关闭
- 这个SQL怎么写?---怎样把多行查询结果集,在一个字段里显示.
- 新手提问,我安装好oracle817客户端后,怎样配置net assistant 连接到oracle服务器?
- ORACLE在创建视图时出错:ORA-00932: 数据类型不一致
- Oracle函数问题!
- 客户端连接oracle提示ora12170 tns连接超时
- 同样的代码,ojdbc驱动,在win10下开发环境报这个异常,win7下正常,求解?
- The Network Adapter could not establish the connection
- 初学者提问
-- 修改成:into :new.
LOGID NUMBER(38) NOT NULL , --自增ID
IMEI VARCHAR2(30), --IMEI
IMSI VARCHAR2(30), --IMSI
CID VARCHAR2(20), --产品ID
PID VARCHAR2(20), --渠道ID
SID VARCHAR2(40), --SID
SKEY VARCHAR2(10), --SKEY
VER VARCHAR2(10), --版本号
LOGCREATIONDATE TIMESTAMP(6) NOT NULL , --安装时间
OSTYPE NUMBER(38), --OSTYPE
PHONETYPE VARCHAR2(20) --机型
);create sequence musicinstalllog_seq start with 1 increment by 1 nomaxvalue nocycle cache 20;CREATE OR REPLACE TRIGGER musicinstalllog_trig_autoinc
BEFORE INSERT ON musicinstalllog
FOR EACH ROW
BEGIN
IF (:new.LOGID IS NULL) THEN
SELECT musicinstalllog_seq.nextval INTO :new.LOGID FROM DUAL;
END IF;
END;
/
create table test (id number, name varchar2(20));
create sequence seq_test start with 1 increment by 1;create or replace trigger tri_test
before insert on test
for each row
when (new.id is null)
begin
select seq_test.nextval into :new.id from dual;
end;insert into test (name) values ('abc');select * from test;
ID NAME
---------- ------------------------------
1 abc
不知道你的錯在哪裡,把你的表的創建語句貼出來看看
-- 修改成:into :new.