Error with Oracle9i

[Yuri]

I work with Delphi5, DOA5 and Oracle8i. After Oracle8i was updated to Oracle9i,
TQuery with "INSERT and RETURNING" ended with the message
"ORA-00439 : feature not enabled : RETURNING clause from this client type".
What is the problem and should I do?

 

[Marco Kalter]

This would indicate that you are using SQL*Net 2.3 or earlier, or that you are using Oracle Net8 ar later in OCI7 mode (TOracleSession.Preferences.UseOCI7 = True).

Could this be the case?

------------------
Marco Kalter
Allround Automations

 

[Yuri]

Sorry, but environment is:
ORACLE NET SERVICES 9.0.1.1.1
TOracleSession.Preferences.UseOCI7 = FALSE.
The same sentence through the BDE completes without any problem.
I have Direct Oracle Access - 5, Standard version, with source
- Serial number: 02-99319
- Licenses: 1
- Base version: 33

 

[Marco Kalter]

Are you sure that Direct Oracle Access is using this 9i client? Could it be that it is using a Primary Oracle Home with SQL*Net?

The error message doesn't seem to leave much room for other speculations...

------------------
Marco Kalter
Allround Automations

 

[Yuri]

I did'nt hear about SQL*Net since Oracle6.
Oracle 9i, Delphi5, DOA(5) are newly installed on the same computer
with Windows 2000 SERVER and
there is no any word in ORACLE9i about SQL*Net.

 

[Marco Kalter]

SQL*Net 2.x is the Oracle 7.x client. Can you make sure that there is no ora7*.dll file on your system?

------------------
Marco Kalter
Allround Automations

 

[Yuri]

The thing is, that till yesterday I had DOA version 3.3.1.
After DOA 3.4.5 was installed, the error disappeared.
Excuse for trouble, thank you.
With respect, Yuri.