Re: error messages.. on the instead of trigger..

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 11 Sep 2002 21:45:39 -0400
Message-ID: <unvsecq5tbs922@corp.supernews.com>

> insert into teams ( teamid, scid, sport, gender ) values
> ( home_team_seq_id, school_id , :new.tsport, :new.tgender);

                                                                     ^^^^^^^^

school_id .... thats your problem. You don't define any variable by that name.

Now once you fix that error ... you will get another set of errors...

Anurag

"eugene kim" <eugene1977_at_hotmail.com> wrote in message news:alnbaj$h9l$2_at_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 - 20:45:39 CDT