OCI function is not linked

[radub]

Hello,

After upgrading the ODAC today, I received the above exception when trying to connect to oracle server (set Connected:=true in TOraSession).

Is there anything new to set up?

Thank you,
Radu B.

[AlexP]

Please specify your Oracle client version

[radub]

Oracle 10g

[olhai]

I have the same issue!

I had to roll back to 9.2.5 -> this version works fine (again).


regards
Oliver

[radub]

Unfortunately I cannot rollback to a previous version, because I am pending of SDAC as well and previous version of SDAC has its own problems.

I need a quick bugfix on this, taking into account that I was waiting for 1.5 months (from 09.01 to 20.02) to deploy the SDAC version on my clients.
Now I am waiting for ODAC (!!!).

Thank you,
Radu B.

[MarkF]

I can confirm that this happens with the Oracle 10.1.0.4.0 client (the only Oracle 10 client I have on the test machine.) The initial "OCI Function is not linked" error is due to a bug in TOracleHome.DetectOCIClientVersion where the 9.2.6 version uses a different GetProcAddress call which returns @NotLink however tests it against nil (it should either check for @NotLink or go back to the older code which used the Windows API GetProcAddress. I've fixed this in my code and the function now properly sets the version. However I then get:

Project x raised exception class EOCIInitError with message 'Can't initialize OCI. Error -1'.

-Mark Ford
Benthic Software

[radub]

Very strange!
This happens since I upgraded from ODAC 6.90 to 9.20 on the same Oracle 10.2g.
On the old version of ODAC everything has worked fine, with no errors.

I insist that is a problem with the DAC not with the Oracle.

Radu B.

[dados]

I have 10.1.0.4 and 11.2.0.1 clients installed
Just upgraded from 9.2.5 to 9.2.6 and I'm also getting "OCI function is not linked" when using the 10.1.0.4 client, the 11.x client works as it did before the upgrade.

Reg,
Arni Thor

[AlexP]

Thank you for the information. We have reproduced the problem on Oracle client versions lower than 10.2 and will upload the fixed build within two days.

[radub]

Very good news.

Thank you,
Radu B.

[AlexP]

The new ODAC build is already available at our website for download now

[dados]

Installed 9.2.7 and it works like a charm

Thanks

[AlexP]

You are welcome. Feel free to contact us if you have any further questions about ODAC.

[radub]

BugFixed.

Case closed.

Thank you,
Radu B.

[AlexP]

Glad to see that you solved the problem.