[hurry]PL/SQL ERROR ORA-06552 ORA-06553:

From: sohn dae ho <hoya1_at_shinbiro.com>
Date: Thu, 26 Aug 1999 09:05:27 +0900
Message-ID: <7q20e6$q9u$1@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 Wed Aug 25 1999 - 19:05:27 CDT