Re: PL/SQL weirdness

Craig Morgenstern (morgenst_at_riogrande.cs.tcu.edu) 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

Any significance in the fact that you declare ssn_count and the error is for snn_count. Or is this what you are saying is weird?

        Helen
: --
 

: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
: Craig Morgenstern / morgenst_at_riogrande.cs.tcu.edu / 817-921-7166 / Ft. Worth TX
: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Fri Nov 15 1996 - 00:00:00 CST