Recent content by Arvid

I get the same problem with Oracle 12. Is it really an Oracle bug that surface in Oracle 12 again?

We have an issue with "RefreshRecord". What happens is that: 1. We fetch data from the database in a TOracleDataset (ODS1) Sql something like SELECT * FROM CUSTOMERS WHERE COMPANY = 'UNKOWN'; 2. This dataset is connected to a TDBGrid where we can choose a customer. 3. We can then execute a...

Hi, sorry for late answer - but I don't get notifications when you reply... As I worte we have a implementation using master/detail - we do need this. No way around. A customer can have 100/1000/10000 (seldom 100000 - but still possible) (contracts/invoices/etc). The user rarley scroll through...

We do set QueryAllRecord to false. But as soon as the user start to move through the dataset the memory consumption builds up. And if the user choose to do an export to EXCEL we need to scroll through the dataset and memory consuption hits the roof. Off course we only need 25-50 records in...

Hi, du to the problem with TOracleDataset and "Out of memory" when the query fetch a lot of VARCHAR2(4000) fields. As I understand TOracleDataset allocated 4000 characters for every field even if there is only a few characters of actual data(?) I have seen the suggestion to set the dataset...

We have a code that use recursion and filter on TOracleDataset to build a menu. In total there are about 1000 filter operations before the menu is finished. On my Windows 7 (64 bit) machine with 8 Gb of memory the menu is created in about 3 seconds. However we have a customer using Citrix on a...

If a function returns VARCHAR2 - the memory consuption of TOracleDataset is too high - for number the memory usage seem to be normal...

TOracleQuery has a normal memory usage.

That is not really an option since we then would need to change how our application work. Can you confirm the problem/bug with regards to using function results in sql's in TOracleDataset? Have you tested it yet? I have just tested implementing a component called ODAC...

As a test I removed the TDBGrid, so the only thing that happend is that data is fetched into at TOracleDataset and directly exported to excel. We also manipulated the oracle functions so that they just return a fixed number/string. To rule out any bugs in the functions. The behavior of the...

We tested the solution you suggested (QBE) - as for just setting QueryAllRecord and CountAllRecords to false, it works fine as long as the customer does not chose to export the data. Something they do since this is a yearly report they have to run... The amount of that is not at all huge - so...

The issue is not really the 145.000 rows but the huge memory usage when querying using functions i TOracleDataset - why is that? Depending om what limitations the customer set they may get 10 rows in the report or 150.000. Do you mean that I will need to check every sql sendt and find number of...

Example: select a.jurpersonid, a.Etternamn, a.fornamn, reskontro.f_test (b.maalepktnr) kommunenr from felles.efjurperson a, kunde.ekkontrakt b where a.jurpersonid = b.kundenr When running this sql - returning 15000 rows of data my application will use 84Mb of memory. If I change the function...

I've got the same problem nicofari "Out of Memory with TOracleDataset" - I found no real answer to his questions. We have a query returning 145000 rows of data. The problem seems to be that TOracleDataset does not handle data from functions in sql results very well. I made a test application...

We are facing the same issue - what is the status of this issue? Can we expect a fix in the soon future?