Re: Invalid Cursor?

From: Gert De Neve <Gert.DeNeve_at_advalvas.be>
Date: Fri, 8 Oct 1999 21:40:48 +0200
Message-ID: <7tlif5$i4u$1@news0.skynet.be>

give an alias to the sum(...) and count(*) ??

Regards
Gert

<amerar_at_ci.chi.il.us> wrote in message news:7tku66$kd4$1_at_nnrp1.deja.com...
>
>
> Hello,
>
> I am getting this error message when I try to run my procedure:
> ERROR at line 1:
> ORA-01001: invalid cursor
> ORA-06512: at "CASH_DEVEL.EJ1_PH_TELLER_CNT", line 88
> ORA-06512: at line 1
>
> Here is my cursor:
>
> CURSOR ph_curs is
> select batchnum, sum(amt_paid), count(*)
> from payment_history where
> amt_paid > 0 and
> date_time_batch_closed > TO_DATE('100519991915','MMDDYYYYHH24MI') and
> date_time_batch_closed <= TO_DATE('100619991915','MMDDYYYYHH24MI')
> GROUP BY batchnum;
> v_ph ph_curs%ROWTYPE;
> .
> .
> .
> LOOP
> BEGIN
> FETCH ph_curs INTO v_ph;
> EXIT WHEN ph_curs%NOTFOUND;
> .
> .
> .
>
> What is wrong with my definition? Can anyone help?
>
> Thanks,
>
> Arthur
> amerar_at_ci.chi.il.us
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 08 1999 - 14:40:48 CDT