PL/SQL weirdness

From: Craig Morgenstern <morgenst_at_riogrande.cs.tcu.edu>
Date: 1996/11/12
Message-ID: <56a515$1vk@unix2.is.tcu.edu>#1/1

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


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Tue Nov 12 1996 - 00:00:00 CST