Re: ORA-01001

From: Hans Zekl <hz_at_tonbeller.com>
Date: Fri, 22 May 1998 10:12:54 +0100
Message-ID: <35654195.DA63A6D0@tonbeller.com>

larionov_at_yahoo.com wrote:

> I created the PL/SQL procedure, and it compiled just fine.
> But when I am trying to execute the procedure
> from SQL*Plus I am getting the error
>
> ORA-01001: invalid cursor
>
> and this error hapens where I am trying to
> fetch the cursor into the variable of type ROWTYPE.
>
> Do you know possible reasons for this error?
> The procedure seems to be very simple.
>
> Any help would be appreciated!

Dear Michael,

This error can have different reasons. A summary of them can be found on Oracle's SupportNotes CD-ROM of August 97 under the title

COMMON CAUSES OF ORA-1001: INVALID CURSOR ERROR I ran into this error, when I created an application which read 5 tables. I solved it be setting the option MAXOPENCURSORS to a higher value and HOLD_CURSORS to YES.

Greetings
Dr. Hans Zekl
Ton Beller AG
D-64626 Bensheim
Germany Received on Fri May 22 1998 - 04:12:54 CDT