Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    5

    Unanswered: 'before insert trigger' works for all tables but this one

    I didn't encounter any problem creating sequence and 'before insert trigger' for all tables except this table

    Could anybody give me some idea? I'll appreciate it!




    Table Structure:
    ADMINISTRATOR_ID NUMBER(9) PRIMARY KEY
    ACCOUNT_NAME CHAR(25)
    ACCOUNT_PWD CHAR(25)

    CREATE SEQUENCE SEQ_ADMIN NOCYCLE NOMAXVALUE START WITH 1;

    create or replace trigger TRIGGER_ADMIN
    before insert on ADMIN
    for each row
    begin
    select SEQ_ADMIN.nextval
    into :new.ADMIN_ID
    from dual;
    end;
    /

    before insert on ADMIN
    *
    ERROR at line 2:
    ORA-06552: PL/SQL: Compilation unit analysis terminated
    ORA-06553: PLS-320: the declaration of the type of this expression is
    incomplete or malformed

  2. #2
    Join Date
    Mar 2003
    Posts
    5
    I'm using oracle 8.1.7, winXP of OS

    I got the error message in SQL*Plus when trying to compile the trigger

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

  3. #3
    Join Date
    Mar 2003
    Posts
    5
    ADMINISTRATOR_ID NUMBER(9) PRIMARY KEY
    ACCOUNT_NAME CHAR(25)
    ACCOUNT_PWD CHAR(25)
    DATE DATE

    ****************************************
    I RESOLVE THE PROBLEM MYSELF.
    THANK YOU ANYWAY!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •