Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL weirdness

Re: PL/SQL weirdness

From: Loyal Barber <lbarber_at_ix.netcom.com>
Date: 1996/11/18
Message-ID: <32906B27.4368@ix.netcom.com>#1/1

Craig Morgenstern wrote:
>
> I'm going crazy! Can anyone give me a clue as to why the follow trigger
> (condensed from a larger piece of code) does not compile? There's no
> identifier named ssn_count in my entire schema. This is 7.3.2 under
> solaris 2.5. Is oracle buggy under solaris? We've just started using
> it this semester and I get an uneasy feeling when encountering problems
> like this.
>
> TIA,
> craig
>
> create trigger weird
> before insert on department
> for each row
> declare
> ssn_count number;
> begin
> ssn_count := 0;
> end;
> /
>
> WEIRD TRIGGER 1 4 3
> PLS-00201: identifier 'SNN_COUNT' must be declared
>
> WEIRD TRIGGER 2 4 3
> PL/SQL: Statement ignored
>
> --
>
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Craig Morgenstern / morgenst_at_riogrande.cs.tcu.edu / 817-921-7166 / Ft. Worth TX
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
I assume you have a typo somewhere. Your error says 'snn_count' where you code says
'ssn_count.' You might check for that confusion. If that is not the problem
then check the code immediately before this. Sometimes PL/SQL gives you an
error message on code that is not wrong, but is several lines after the error.

Loyal Received on Mon Nov 18 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US