Re: PL/SQL weirdness

In article <56a515$1vk_at_unix2.is.tcu.edu>, morgenst_at_riogrande.cs.tcu.edu says...

>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.

It works OK for me on Solaris:

SQL> create table test as select * from dual;

Table created.

SQL> create trigger wierd
  2 before insert on test
  3 for each row
  4 declare
  5 ssn_count number;
  6 begin
  7 ssn_count := 0;
  8 end;
  9 /

Trigger created.

So I guess it isn't the O/S version or whatever. Have you tried a different identifier name to be on safe side?

Cheers.

Martin. Received on Wed Nov 13 1996 - 00:00:00 CST