Recent content by dgsmith

Thank you for the response. I don't have access to Oracle server logs, but we spent some time with DBAs on this issue a couple years ago and they said they saw nothing. Network people said they could monitor traffic and see what's going on if I could make it happen on demand, but I can't. I...

We have an intermittent problems with communications between clients and Oracle servers (both Windows.) We may see ORA-12170: TNS:Connect timeout occurred or ORA-03113: end-of-file on communication channel. When this happens there is no error on the Oracle server. We believe it is a network...

Never mind, I had missed "Homogeneous". Working for me now with Homogeneous=true and PoolType=ptDefault.

TOracleSessionPool doesn't work with the Oracle Secure External Password Store using either ptOracle or ptDefault, is this correct? I'm using Delphi 10.1 and the Oracle 11g client on Windows 7. Thanks.

Turns out I was using the evaluation version. Our manager had downloaded the file for us, and I didn't notice that it didn't ask for a key when I installed it. I installed the registered version, and it's working fine now.

TOracleSession.Create( nil)

I have and ISAPI DLL that hanges on the first call to TOracleSession.Create under XE5 and DOA 4.1.3.5. If I compile the same project under XE3 and DOA 4.1.3.3 it works. I'm using the 11g client. Any assistance would be much appreciated! Thanks, David Smith

Thanks so much. That worked.

I have just installed the 11g client on a server with the 8.1 and 9.2 clients already installed. This server is used to run scheduled console apps, many of which have not been recompiled for years. They now give: Initialization error Could not locate OCI dll OracleHomeKey...

I'd like to see some examples of code that uses the object version of Direct Oracle Access to work with XMLtype fields, but I haven't found any. If someone could direct me to (or post) one, I'd appreciate it. Thanks.

That worked fine. Thanks. I also had a problem with TOracleDirectPathLoader.DateFormat. If I set it I got an access violation on Prepare. When I set it on the columns it works fine.

Is it possible to set date fields to null with the direct path loader?

That seems to work for us too. Thanks! David

Is there a way to create an Oracle alias at runtime, other than to write directly to TNSNames.ora? Or, is there a way to connect to a database for which no alias is defined? David Smith

I'm trying to use TOracleDirectPathLoader, following the example in the help file. I'm processing multiple data files; the first goes fine, and the second goes fine until the Finish method is called, when I get 'ORA-00600: internal error code, arguments: [ktssinseg1], [], [], [], [], [], []...