connecting from coldfusion10 enterprise edition to oracle 12c database
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..
