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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01001 Invalid cursor

Re: ORA-01001 Invalid cursor

From: <vick9935_at_my-dejanews.com>
Date: 1998/10/12
Message-ID: <6vtr55$6rf$1@nnrp1.dejanews.com>#1/1

Nevermind, I figured out the problem. I was referring to an array...outside of its upper bounds.

Sure wish I could have gotten a better error message <g>.

Brian

In article <6vtl3e$v21$1_at_nnrp1.dejanews.com>,   vick9935_at_my-dejanews.com wrote:
> I have a reference cursor used in a stored procedure...with the record type
> defined in a package spec. The package & package body (where the procedure is
> located) compiles fine. However, my front-end application is giving me an
> "invalid cursor" error.
>
> I've successfully executed stored procedures returning reference cursors in
> the past; however, this cursor has 121 columns...the SELECT statement is 7989
> characters long.
>
> The Oracle documentation says that it may be necessary to increase AREASIZE;
> however, another portion of the documentation says that this parameter is
> obsolete in version 7.0. I would not know where to increase this parameter
> anyway (or MAXOPENCURSORS).
>
> Any other ideas of what the problem might be?
>
> Thanks,
>
> --
> Brian in Seattle
> Pride, commitment, teamwork - words we use to get you
> to work for free.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

--
Brian in Seattle
Pride, commitment, teamwork - words we use to get you
to work for free.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Mon Oct 12 1998 - 00:00:00 CDT

Original text of this message

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