We are testing Oracle 12.1.0.2 and seeing problems with stored procedure output parameter values being chopped off, and associated when we use the 12.1.0.2 ODBC driver (we use the 32-bit version). We see a Function sequence error each time this happens, also.
As an example, one stored procedure takes an NVARCHAR2 name and passes it out as a separate NVARCHAR2 output parameter. Using the 12.1.0.2 ODBC driver, if we pass in 'Basketball' the output may be 'Baske' (along with a Function sequence error).
This is happening for several of our stored procedures. We do not get the function sequence errors nor the truncated output parameters if we use the 12.1.0.1 version of the ODBC driver connecting to our 12.1.0.2 database, nor if we use the 11.2.0.4 or 11.2.0.2 version of the ODBC driver.
Is this a known issue in the 12.1.0.2 ODBC driver?
Thank you,
Daniel Meyer