SQL*Plus: Release 8.1.6.0.0 - Production on 星期三 11月 27 17:48:18 2002(c) Copyright 1999 Oracle Corporation. All rights reserved. 连接到: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - ProductionSQL> conn user1/user1@gforacle 已连接。 SQL> CREATE OR REPLACE TRIGGER USERADD 2 BEFORE INSERT ON MEMBERRG 3 referencing old as old new as new for each row 4 BEGIN 5 new.country_id=MYADD.nextval; 6 END; 7 / BEFORE INSERT ON MEMBERRG * ERROR 位于第 2 行: ORA-00942: ??????? SQL> CREATE OR REPLACE TRIGGER USERADD 2 BEFORE INSERT ON MEMBERRG 3 referencing old as old new as new for each row 4 BEGIN 5 new.country_id=MYADD.nextval; 6 END; 7 8 / BEFORE INSERT ON MEMBERRG * ERROR 位于第 2 行: ORA-00942: ??????? SQL> SQL> CREATE OR REPLACE TRIGGER "USER1"."MYINSERT" BEFORE INSERT ON "USER1"."MYDBS" 2 begin 3 new.country_id=MYADD.nextval; 4 end; 5 /警告: 创建的触发器带有编译错误。SQL> CREATE OR REPLACE TRIGGER "USER1"."MYINSERT" BEFORE INSERT ON "USER1"."MYDBS" 2 begin 3 :new.country_id := MYADD.nextval; 4 end; 5 /警告: 创建的触发器带有编译错误。SQL> CREATE OR REPLACE TRIGGER USERADD 2 BEFORE INSERT ON MEMBERRG 3 referencing old as old new as new for each row 4 BEGIN 5 new.country_id=MYADD.nextval; 6 END; 7 / BEFORE INSERT ON MEMBERRG * ERROR 位于第 2 行: ORA-00942: ??????? SQL> 拜托各位老大,在你们机子上试一下好不好,我有个字段是ID,你们的存贮过程都没关联上!
SQL*Plus: Release 8.1.6.0.0 - Production on 星期三 11月 27 17:48:18 2002(c) Copyright 1999 Oracle Corporation. All rights reserved.
连接到:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - ProductionSQL> conn user1/user1@gforacle
已连接。
SQL> CREATE OR REPLACE TRIGGER USERADD
2 BEFORE INSERT ON MEMBERRG
3 referencing old as old new as new for each row
4 BEGIN
5 new.country_id=MYADD.nextval;
6 END;
7 /
BEFORE INSERT ON MEMBERRG
*
ERROR 位于第 2 行:
ORA-00942: ???????
SQL> CREATE OR REPLACE TRIGGER USERADD
2 BEFORE INSERT ON MEMBERRG
3 referencing old as old new as new for each row
4 BEGIN
5 new.country_id=MYADD.nextval;
6 END;
7
8 /
BEFORE INSERT ON MEMBERRG
*
ERROR 位于第 2 行:
ORA-00942: ???????
SQL>
SQL> CREATE OR REPLACE TRIGGER "USER1"."MYINSERT" BEFORE INSERT ON "USER1"."MYDBS"
2 begin
3 new.country_id=MYADD.nextval;
4 end;
5 /警告: 创建的触发器带有编译错误。SQL> CREATE OR REPLACE TRIGGER "USER1"."MYINSERT" BEFORE INSERT ON "USER1"."MYDBS"
2 begin
3 :new.country_id := MYADD.nextval;
4 end;
5 /警告: 创建的触发器带有编译错误。SQL> CREATE OR REPLACE TRIGGER USERADD
2 BEFORE INSERT ON MEMBERRG
3 referencing old as old new as new for each row
4 BEGIN
5 new.country_id=MYADD.nextval;
6 END;
7 /
BEFORE INSERT ON MEMBERRG
*
ERROR 位于第 2 行:
ORA-00942: ???????
SQL>
拜托各位老大,在你们机子上试一下好不好,我有个字段是ID,你们的存贮过程都没关联上!