Re: URGENT NEED OF HELP ABOUT PL/SQL

Well, what error did you get?

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 Wed Aug 27 1997 - 00:00:00 CDT