PL/SQL Error when using trigger...

From: sohn dae ho <hoya1_at_shinbiro.com>
Date: Tue, 24 Aug 1999 16:20:47 +0900
Message-ID: <7pth99$m3e$2@hiline.shinbiro.com>

When using trigger there was some error...

SQL> CREATE OR REPLACE TRIGGER TRG_I_OWNER   2 BEFORE INSERT ON "OWNER_INFO"
  3 FOR EACH ROW
  4 DECLARE
  5 I INTEGER;
  6 BEGIN
  7 IF :NEW.STORE_NO IS NULL THEN
  8 SELECT STORE_NO_SEQ.NEXTVAL INTO I FROM DUAL;   9 :NEW.STORE_NO := I;
10 END IF;
11 END;
12 /
CREATE OR REPLACE TRIGGER TRG_I_OWNER

                          *

< Error>

ERROR at line 1:
ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed

Can anyone help me with this??? Received on Tue Aug 24 1999 - 02:20:47 CDT