blank EOracleError

[petebr]

under Delphi 6 sp2 - DOA 4.0.6.2
Oracle 10g

When our Websnap application is running as a .dll we get a blank EOracleError on the Logon method for OracleSession.
This works fine when compiled as an exe (running under Delphi's web app debugger using com+)

I don't have DOA source code so can't trace any further.

Any ideas?

Pete

 

[Marco Kalter]

Are you sure this is an EOracleError? If so, what is the EOracleError.ErrorCode?

 

[petebr]

The EOracleError.ErrorCode is 0

 

[Marco Kalter]

0 indicates "no error". Can you verify if the .exe and .dll use the same Oracle Net version, run with the same access rights, and the same PATH environment?

 

[petebr]

How do you tell? This has only been an issue since moving to 10g, I have removed all references to older clients. How does DOA decide which Net version to run?

 

[Marco Kalter]

This is only relevant if you have multiple Oracle Homes. DOA uses the Primary Oracle Home, which is the home that is listed first in the PATH environment variable. If you want to check this from within the application/dll, inspect the OCIDLL variable in the OracleCI unit.