Re: ora-01001 error

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 27 Aug 2002 14:04:32 +0200
Message-ID: <ckqmmusur73ib1g24svfdjm6tnjnvh4q4k@4ax.com>

On Tue, 27 Aug 2002 10:52:28 +0000, shiju <tshiju_at_ford.com> wrote:

>
>hi,
>I have a pro C file with i am able to work with in Oracle 8i.
>I used the same ProC file and generated the exe and run the application
>in Oracle 9i envirnment. Here in Oracle 9i , i am getting the error
>ORA-01001: invalid cursor .
>What the oracle document says is to correct the Cursor ,
>Or increase the values of Pre-compiler options MAXOPENCURSORS and
>AREASIZE.
>But the problem is not with the cursor and MAXOPENCURSORS, and AREASIZE
>is a depricated option after Oracle 7 and PRO C 2.
>
>Any help in this regard is highly appreciated.
>
>Thanks in advance.
>Shiju

Other options are: the cursor is not open or
the statement didn't parse and you didn't trap this.

This is what my crystall ball, without looking at actual code, tells me.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Aug 27 2002 - 07:04:32 CDT