Re: URGENT NEED OF HELP ABOUT PL/SQL

What exactly is the error ? Error text, error code ?

Matteo Lonardi wrote:
>
> I have the following code:
>
> SELECT COUNT(*) INTO counter FROM event WHERE event_code=cev;
>
> My problem is that an error occurs and I'm not able to understand why.
> I've tried to change the row and write:
>
> SELECT TO_CHAR(COUNT(*),'9') INTO string_counter FROM event WHERE
> event_code=cev;
>
> This one works BUT there is another problem: I have to know how many
> rows exist in order to declare the right dimension of string_count but
> if I knew this information I could avoid to do the SELECT.
>
> Well, does anybody know how can I solve it?
> Thanks in advance.
>
> Lonardi Matteo
> teo_at_romeo.sci.univr.it
Received on Thu Sep 04 1997 - 00:00:00 CEST