Upgrade to 10g problems

[MStith]

I have been using Kylix 3 with Oracle 8i and 9 for a long time now. Our hosting provider is forcing us to upgrade to 10g. They have made the switch on the test environment, and now we are getting errors like:

A query with LOB's requires OCI8 mode, but OCI7 mode is used

ORA-00439: feature not enabled: RETURNING clause from this client type

I have looked at the source (Oracle.pas) and see where the LOB error will return this if ASession.UseOCI80 is not true (which is set reverse of UseOCI7)

We have 4.0.3 and Kylix 3

Our Oracle Session Preferences are set
UseOCI7 = False

What could be the problem with 10g

 

[Marco Kalter]

Are you sure the application is linked with the 4.0 units? This error typically indicates a 3.4 or earlier compatibility issue with 10g.

 

[MStith]

Yes, All I have installed is the 4.0.3

I have found in other posts about similar issues, and the result was to install the 4.0.4 and later build, but for kylix, the only one listed was the 4.0.3.

This same setup has worked for quite some time now. It works now in the development environment for 8i, and in the production evnironment for 9, but the test environment is now upgraded to 10g and it does not work.

Same executables (cgi and so) with apache.

 

[MStith]

Any word on this yet?????

 

[Marco Kalter]

This was indeed fixed in 4.0.4, for which we don't have a Kylix version. Do you have the source code?