我新下载的oracle 10g release2版本,安装什么的都很正常。但是当我要为我的table创建一个tigger的时候出现了一个错误,错误描述:索引中丢失IN或OUT参数::1
请问怎么解决?
我的序列生成代码:
CREATE SEQUENCE "SYSADMIN"."NORMALCAR_ID" INCREMENT BY 1 START
WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
CACHE 20 NOORDER
我的触发器生成代码:
CREATE OR REPLACE TRIGGER SYSADMIN."TIG_NORMALCAR_ID" BEFORE
INSERT ON "SYSADMIN"."TB_NORMALCAR" FOR EACH ROW
begin
select normalcar_id.nextval into:new.ID from dual;
end;
请问怎么解决?
我的序列生成代码:
CREATE SEQUENCE "SYSADMIN"."NORMALCAR_ID" INCREMENT BY 1 START
WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
CACHE 20 NOORDER
我的触发器生成代码:
CREATE OR REPLACE TRIGGER SYSADMIN."TIG_NORMALCAR_ID" BEFORE
INSERT ON "SYSADMIN"."TB_NORMALCAR" FOR EACH ROW
begin
select normalcar_id.nextval into:new.ID from dual;
end;
CREATE OR REPLACE TRIGGER SYSADMIN."TIG_NORMALCAR_ID" BEFORE
INSERT ON "SYSADMIN"."TB_NORMALCAR" FOR EACH ROW
begin
select normalcar_id.nextval into :new.ID from dual; --into :new.ID隔开点
end;