Re: PACKAGE PROBLEM
From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Mon, 29 Mar 1999 21:43:19 +0200
Message-ID: <7dol4r$220$1_at_weber.a2000.nl>
Date: Mon, 29 Mar 1999 21:43:19 +0200
Message-ID: <7dol4r$220$1_at_weber.a2000.nl>
agichen wrote
> I have a table "sample" as follows,
>
> count varchar2(2) name ( varchar2(10))
> 01 MARY
> 02 JACK
> 03 KEVIN
> What's wrong ?? Any idea,
COUNT is a reserved word in PL/SQL. I even wonder how you got the table defined in the first place, for I would have thought that COUNT is a reserved word in SQL as well. Rename the column count to something else and it will work.
By the way, why declare a column named COUNT as a varchar?
Arjan. Received on Mon Mar 29 1999 - 21:43:19 CEST