Copy link to clipboard
Copied
i am facing issues when upgrading coldfusion 6 to coldfusion 10 (Enterprise) using oracle 12c database.
in CF10 Administrator data & sources tab selecting others drop down here providing jdbc:macromedia.oracle:<servername>:port:SID;
Driver class name : macromedia:jdbc:MacromediaDriver
having jar files are OJDBC7 & OJDBC 14 in my Web sphere CFFUSION/LIB folder .
When calling one of the Stored Procedure in my application procedure using 3 reference cursors
Getting error message like : Error executing database query : Jdbc [macromedia ][oracle jbbc drivers][oracle][ora-20001].error encountered -2074-ORA-06512 : cannot set nls in Distributed transcations..
There is other senarion which i can able to get the data from other stored procedure if the procedure using 1 or 2 reference cursors..
using cfprocresult tag for results in stored proc..
Please let me know how do I achieve result by using 3 reference cursors ..
Thanks in advance..
Copy link to clipboard
Copied
There are a few threads about CF10 and Oracle 12c. The bottom line is that its not supported so things probably will not work - Has anyone started testing CF 10 with Oracle 12c yet?
You could start by trying the oracle class name - oracle.jdbc.OracleDriver