"Index out of bounds (n)" / "Fetch out of sequence.."

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Vittorio

"Index out of bounds (n)" / "Fetch out of sequence.."

Post by Vittorio » Sun 27 Feb 2005 09:06

I use ODAC (last build) with Delphi 7 in a Windows XP service application with different Threads.
Every thread query the same Oracle 10g DB using an indipendent TOraSession. NET option is OFF.

Sometimes (very often) an "Index Out of bounds (n)" exception is released opening (calling .Open) a simple query (TSmartQuery) like "SELECT .. FROM .. WHERE .. ORDER BY".

Sometimes scrolling records result of a TSmartQuery, a "Fetch out of sequence.." exception is released.

Both query are read-only.

I don't use NET option but I have tried it : errors are more frequent !

Previus build of ODAC has the same problems.
I think ODAC is not a very thread safe component ...

Can you help me ?

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 28 Feb 2005 11:41

Send us please small demo project to demonstrate the problem and include script to create server objects to ODAC support address.

Post Reply