Re: Help, please. Trouble with validate trigger...

From: Norman Dunbar <Norman_at_JUNKTHISBIT.Bountiful.Demon.co.uk>
Date: Wed, 09 Jun 2004 16:10:42 +0100
Message-ID: <as9ec0dl9mrd3ngngij6r2rmgd0jnj1ui9@4ax.com>

On 9 Jun 2004 06:46:24 -0700, crwng_at_comcast.net (Rob) wrote:

>I'm trying to implement the following trigger on an Oracle 9i database
>(running on Solaris 8) with three tables. The tables are
>
>LR_READER
>LR_ATTRIBUTE
>LR_READERATTRIBUTE
you are missing a few '/' after the 'end;' statement for your triggers.

Check out this line :

        CURSOR c1 (fkVal1 NUMBERPS) IS

What is a NUMBERPS data type :o)

Try this is sqlplus :

SQL> alter trigger VALIDATEFK_5B512FC0 compile;

Warning: Trigger altered with compilation errors.

SQL> show errors
Errors for TRIGGER VALIDATEFK_5B512FC0:

LINE/COL ERROR

---

---

6/2      PL/SQL: Item ignored
6/20     PLS-00201: identifier 'NUMBERPS' must be declared
13/2     PL/SQL: SQL Statement ignored
13/7     PLS-00306: wrong number or types of arguments in call to 'C1'

SQL> Have fun.

Cheers,
Norm.

Remove the obvious bit to reply to my email address. Received on Wed Jun 09 2004 - 10:10:42 CDT