For one thing, you don't need to install and configure BDE when using DOA, and the performance using DOA is lots better than using BDE, for me it is not an option going back to BDE.
I seems when I upgrade to the latest version of DOA the problem disappears (however, I do get a bunch of other problems instead, but those I can solve). Is there a patch to fix this or do I need to buy a new licence?
Under certain circomstances I get a EListError 'List index out of bounds(3)' when using Delphi 5 and DOA 3.4.1. I don't have the source code for DOA but using the CPU Window I traced the error back to TOracleDataSet.SyncDetails
Any ideas what could cause this error?
I insert e new record in a table (TOracleDataset). The primary key is assigned automatically by a trigger. I would like the end user to be able to see this primary key right after creating a new record (after calling Table1.Insert).
I set RefreshOptions = [roAfterInsert]
If I do...
I have no experience with ODAC from Core Labs, maybe I should have a look at them. But I can say one thing about DOA. It's a safe card. I've been working with DOA for a few years now and I never had any real problems with them and if you do the support is very good.
//Jonas
When using TOracleEvent to handle alert messages everything seems to go very slow.
I use Delphi 5, DOA 3.4 and Oracle 8.0.6. When initialising my app I call
OracleEvent.Start.
After this each query I issue (even simple select queries that don't trigger anything that sends alert messages)...
1)
If you are using a TOracleDataset you can set property QueryAllRecords := False;
2)
Or you can exclude you blob-field from the fields in the select statement (or double click the query and add all fields except for the blob field). You will then need another query to request only the blob...
It would be great if one could cut and paste whatever that is displayed in the debug-window when property Debug is set to true for a TOracleQuery or TOracleDataset. This way one can paste it into SQL-Plus to see what is actually wrong with it.
//Jonas
I have problems reading and writing language specific characters (Swedish aa ae o, german u etc). We have an Oracle 8 server running on a unix box and a web application (storyserver/tcl based) that writes data into some tables, long and varchar2 fields.
We also have an administrative tool...
Calling a procedure can be done iether through the TOraclePackage component or by executing a TOracleQuery containing the following SQL statement:
begin
add_something(:a, :b);
end;
for example if you have the following procedure:
create or replace procedure add_something(
a in number;
b...
I'm developing a component having a TOracleSession property. When this property is assigned the component information is updated if the OracleSession is connected. I would also like to update the information when the OracleSession is connected (incase it wasn't from start or if it was...