Invalid Cursor?

From: <amerar_at_ci.chi.il.us>
Date: Fri, 08 Oct 1999 14:13:39 GMT
Message-ID: <7tku66$kd4$1@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 - 09:13:39 CDT