error messages.. on the instead of trigger..

From: eugene kim <eugene1977_at_hotmail.com>
Date: Wed, 11 Sep 2002 19:14:34 +0000
Message-ID: <alnbaj$h9l$2@newsreader.mailgate.org>

56/25 PL/SQL: ORA-00984: column not allowed here are somewhere around here
i use emacs/sql mode.. line numbers in error message doesn't seem to match exactly..
which makes debugging harder..

thank you again..

                select id_seq.nextval into home_school_seq_id from dual;
                select id_seq.nextval into home_team_seq_id from dual;

                insert into schools (scid, scname) values (home_s
chool_seq_id, :new.tsc_1);
                insert into teams ( teamid, scid, sport, gender ) values
                                ( home_team_seq_id, school_id , :new.tsport, :new.tgender);
                end if;
        

SQL> Errors for TRIGGER GAMES_VIEW_TRIGGER:

LINE/COL ERROR

-------- -----------------------------------------------------------------
55/3     PL/SQL: SQL Statement ignored
56/25    PL/SQL: ORA-00984: column not allowed here
73/4     PL/SQL: SQL Statement ignored
73/31    PLS-00201: identifier 'VISITOR_TEAM_SCHOOL_SEQ_ID' must be
         declared

73/58    PL/SQL: ORA-00904: : invalid identifier
84/3     PL/SQL: SQL Statement ignored

85/28 PL/SQL: ORA-00984: column not allowed here SQL> Received on Wed Sep 11 2002 - 14:14:34 CDT