Recent content by ldsandon

IOT uses logical row ids, which can change. Didn't Oracle introduced Universal Row IDs (UROWID type) to resolve this issue? Can DOA handle UROWIDs?

If a TOracleSession is initialized using another session Share() method, is that session "thread safe"? I mean, if it is used by a given thread only are calls safe as if it was initialized separately, or because the connection is shared they are not, and calls must be synchronized some way?

I've encoutered this problem also today. An application with 8 threads each with its own session faulted everytime I launched it (after a few minutes) with "External exception EBF00BAA", I've tried to obtain a stack trace with little luck. It took time to trace it to the OCI client. Tested with...

Because the documentation still only says "Creates a new", in which format the string should? Should it be compliant with local NLS parameters? Which conversion function is applied to the string?

It would also be nice to be able to set timezone offsets as time zone names. For example I am building an interface to the Oracle scheduler, and I found that if you submit a job using the TZ name Oracle will automatically take into account daylight saving times, while if a TZ is specified as a...

TOracleTimstamp can return timezone offsets, but doesn't return timezone names. OCI can return them, using OCIDateTimeGetTimeZoneName(). Could it be added?

Maybe it could use and check already existing ProviderFlags? It would use the same machanism used by datasnap.

Isn't Advanced Security a database options to be licensed separately? A cheaper solution may be to configure IPSec between client and server, although it does not protect end-to-end (Data get encrypted/decrypted between network endpoints, but between the network and application/database they are...

AFAIK Unidirectional was introduced by CodeGear to avoid to cache data twice, one on the "source" dataset and one on the "user" dataset, usually TClientDataset, or when cahcing data was useless - dbExpress works that way because TClientDataset caches data. Because Datasnap can work in a...

The one raised by TRecordDataList.RecordAt() when using a M/D with each dataset set to unidirectional (using Datasnap and TDatasetProvider, D20007, DOA 4.0.7), see my other post about it. It's ok for design time errors, but application error shouldn't be reported that way - as noted services and...

I have a TRemoteDatamodule (DOA 4.0.7, Delphi 2007) where there are three datasets set in master->detail->detailofdetail relationship. A provider is attached to the master dataset, and details are handled the Datasnap way, embedded as TDatasetFields within the datapacket. When Unidirectional is...

I have bought the DOA code. In several places it raises an exception, then traps it and calls ShowMessage(), sometimes re-raising the exception, sometimes handling it. Check for example: TOracleSession.ReactivateDataSets; TOracleTableInfo.GetColumns; TRecordDataList.RecordAt(Index: Integer)...

I saw that instead of just raising an exception, sometimes DOA handles the exception and shows a dialog by itself (using 4.0.7). The problem surfaces when DOA are used in a service or a DCOM server that runs under a specific user credential: the application has its own windows station and...

Again, I have to ask if Share() shares the connection or the session, because I have encountered the following issue: I have a Datasnap server that uses child datamodules. A main session is on the main remote datamodule, and it is passed to child datamodule when those are created. When I connect...

Any plan to implement proxy user support? Now we are being requested to implement auditing and other compliance functions, and it would be a welcome addition. AFAIK the OLEDB driver supports it, I wouldn't like to be forced to switch to it.