Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with cursor

Re: Help with cursor

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 9 Oct 1999 17:00:03 GMT
Message-ID: <7tnsaj$ebj$1@news.seed.net.tw>

<amerar_at_ci.chi.il.us> wrote in message news:7tku7n$kdi$1_at_nnrp1.deja.com...
> 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?

You didn't open the cursor. Received on Sat Oct 09 1999 - 12:00:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US