Recent content by GI

Beware of any DDL statements like Create Table or something like that. These statements are appended by Oracle with a silent Commit command which removes any pre-defined Savepoint

Hello Under D7 Ent and DOA v4.0.6.2 try the following case: Use a TOracleQuery with a bind variable :DATEVAR of type otDate and the Sql statement SELECT COL1,COL2 FROM TABLE1 WHERE COL3

Hello Marco I need to store in my database many large Blobs and the TOracleDataSet.CompressBlobs property sounds great regarding the size-control of my database. I want to use a TOracleQuery (not a TOracleDataSet), since it's a lot of faster than a TOracleDataSet and there's no need for...

Could it be that in your TOracleDataSet you've set the CountAllRecords to TRUE ? If so, then before the execution of the TOracleDataSet's SQL the "Select Count(*) from (TOracleDataSet.SQL)" is being executed. If your TOracleDataSet.SQL is something like "Select MySequence.NextVal From Dual" then...

Under D7, Oracle 9i R2 and the latest DOA I've tried to implement the example that comes with the on-line help about the TOracleDirectPathLoader. When I'm about to execute the Prepare procedure I get the error message "Access Violation at address 606D65C1 in module 'OraClient9.Dll'. Read of...

Don't know for for sure about Oracle 9i but for Oracle 8i the Oracle Lite uses ODBC. So you can't use DOA for Oracle Lite.Of course I may be wrong.. ------------------

Hello I'm trying to apply an SQL Break for long running queries, but seems I can't make it work.I've a long running query which retrieves 375000 rows an includes an order by clause. The whole query takes about 75 seconds before it starts bringing data (all these in SQL PLus) and about 1.5 hours...