OCI Internal error - Help!!!!!!!

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 14 Apr 2003 15:44:06 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7038CEFEB@lnewton.leeds.lfs.co.uk>

Hi Boris,

is your statement selecting either a NULL or a literal as the final column ?
If so you could be hitting a bug which is supposed to be fixed in release 9013 - see Oracle Bugs 2126389 and 2219488.

I'm doing some OCI stuff myself at the moment, and I have not hit this problem, yet !

Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Boris Kesarev [mailto:boris.kesarev_at_infopulse.kiev.ua] Posted At: Monday, April 07, 2003 10:56 AM Posted To: server
Conversation: OCI Internal error - Help!!!!!!! Subject: OCI Internal error - Help!!!!!!!

Hi,

I work with Oracle 9.2.0.2. My developing environment VC++ 6.0, OCI library.

I have got problem with scrollable cursors, which happens when i tried to
get scrollable cursor with count of records more then several thousands. Problem appears as OCI Internal error. It happens only when i try to perform
OCIStmtFetch2(OCI_FETCH_LAST) or just reach by OCIStmtFetch2(OCI_FETCH_NEXT)
2000th record for example.
If i use nonscrollable cursor with the same SQL query everything is ok

Maybe somebody met the such problem or maybe i did not do some necessary initialization? Can somebody help?

One detail: it works thought connection pool but i don't think that it could
be problem.

Best regards
Boris Kesarev Received on Mon Apr 14 2003 - 09:44:06 CDT