Recent content by Daniel Stoch

Try to use Oracle 10.2.0.1.0 Instant Client. We had a similar problem (Access violation at address 00000000. Read of address 00000000) and a new version of instant client solves it. -- Best regards, Daniel

Hi all, We have the same problem in our application. Of course, the problem is undeterministic and occurs on Oracle 10.2.0.1 when we are using client version 9.x.x.x or 10.1.0.4. But it seems that with instant client 10.2.0.1 everything works fine (as Thomas notice in his test). PS. To use...

Hi, Probably you have many string fields or long string fields in your DataSet. Look at the topic: "String fileds vs Memory usage", there is a small description of this problem: http://www.allroundautomations.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=001815 Unfortunatelly we talked about...

Hi, Is there any chance for implementing this functionality, described in this thread over one year ago? Or is it, like people says in my country, "the dream of cut head"? :) Best regards, Daniel Stoch

Hello, Is there any news, when this "feature requests" list will be avaliable? Best regards, Daniel Stoch

Hi, We use Oracle10g instant client with DOA 3.4.5 and everything works fine ;) (well ok, but with Oracle 9i database :) ). Greetings Daniel Stoch

Really the problem is not as easy as you al0 think and you will recognize it if you would think a little :p . Have you read my first message carefully? I write about the same solution. But... We have one thread in our VCL application. User scrolls to the last record then application hangs until...

I think you don't understand me ;) . I know that I can use the AfterFetchRecord event handler to stop the operation, by asking the user if he wants to continue after fetching N (eg. N = 1000) records. I have such functionality already implemented. But users are very unsatisfied that they must...

Hi, I want to allow user to stop fetching records in TOracleDataSet. There is a very good example about activating dataset in a thread, but the problem is when user wants to scroll data in active dataset? I have the following situation, eg.: - OracleDataSet.Active := True -> fetching first 100...

Hi, Copying the results into a memory table takes some time. Holger, your solution for me sound like: "why don't you create a new TDataSet descendant class, inherited form TkbmMemTable, which will be using TOracleQuery for fetching records" :) . It looks like a new implementation of...

Hi, I know that TOracleQuery can do this, but I need a TDataSet functionality :( . So I must find another solution. Thanks for your answer. Best regards, Daniel Stoch

Hi, Is there possible to select in TOracleDataSet BLOB (CLOB, etc.) column as a LOB locator pointer (OCILOBLocator or something like this) and store value in eg. TFloatField (not in TBlobField)? Then I will be able to use this pointer later to create a TLOBLocator (I don't know how, yet ;) )...

Exactly, this a good example. Another one: we browse in our application data from many diffrent selects. And all results are cached on client (for reducing unneeded quering of DB). Then if these selects contain data from Varchar2 fields, application can very fast eat 100MB of system memory. And...

Hi, It depends on situation. For example when you only browsing data (and cache data on client application) from many SQL queries, I think the cost should not be such big. Another thing is that now computers are quite fast (CPU and memory), so cost of dynamic alloc/dealloc should not overweight...

Hi, Thanks for your answer Marco and thank you Jens for joining this topic. I think it would be great if you will be able to implement this feature. In our application we process huge amount of data, so effective memory management is a very important for us. Good luck, Daniel