Problem with Unicode 11g Database

[lecare039]

I have a critical issue with Oracle11gXE and Oracle 11gR2 Unicode Databases. Apperently some Datasets write into wrong datafields when inserting. This happens when a returning clause with rowid is used. The problem exists with only some of the datasets I use that have a returning clause.

I did some researches and notices that 'the variables corresponding to the RETURNING...INTO placeholders must be bound in OCI_DATA_AT_EXEC mode', according tohttp://docs.oracle.com/cd/B19306_01/appdev.102/b14250/oci05bnd.htm#i423484. Appearently DOA does not use OCI_DATA_AT_EXEC for variables. This might cause the problem.

 

[Marco Kalter]

This is indeed a known Oracle Bug, where a bind variable with a certain buffer size for the returning into clause can cause these issues. You will have to upgrade to the latest version to fix this.