Re: ORA - 01001 - Invalid cursor

A cursor is a pointer to an area in memory where all information about a sql statement is being held.
You create a cursor
You associate a statement with it
When you open the cursor you parse it
then you start fetching from it
finally you close the cursor.

Ora-1001 can mean only one thing.
The statement associated with this cursor didn't parse succesfully, and your application didn't trap this error and is continuing beyond it. As soon as a reference is being made to the cursor (eg at the first fetch) you will run into ora-1001.
If you one way or another are capable of tracing the session, the erroneous statement will appear in the trace file, with an associated error message.

Hth,

Sybrand Bakker, Oracle DBA
Sid <sid.james_at_virgin.net> wrote in message news:38D282C1.2754_at_virgin.net...
> Hi,
> an Oracle application we use keeps coming up with this error. Any idea
> what it could be? I'm afraid I don't know what a cursor is in
> Oraclespeak.
>
> Thanks.
>
> Ed.
Received on Fri Mar 17 2000 - 13:39:38 CST