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

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 12 Sep 2002 22:23:37 +0100
Message-ID: <3d811621$1_2@mk-nntp-1.news.uk.worldonline.com>

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:unvsecq5tbs922_at_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
>

I agree with Sybrand and Billy. The OP should do his own homework. If we do it for him, more fool us.

Paul Received on Thu Sep 12 2002 - 16:23:37 CDT