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 -> OCI Internal error - Help!!!!!!!

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

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 14 Apr 2003 16:10:59 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7038CF718@lnewton.leeds.lfs.co.uk>


Hi Boris,

I've just set up a small test on 9i release 2 (9.2.0) and selected from a table which has 41,500 rows in it. The only problem I have doing a 'select last' is the time it takes to get to the last row :o) - this is for a statement like 'select a,b,c from table'.

On the other hand, when I do something like 'select a,b,c,'text' from table' the OCIStmtFetch2() call blows up after about 2 mins trying to fetch the last row. Looks like the problem still exists.

Other than that, it works fine and I can scroll around quite happily in the cursor.

Cheers,
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

-------------------------------------
Received on Mon Apr 14 2003 - 10:10:59 CDT

Original text of this message

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