Skip to main content
Participant
February 10, 2017
Question

connecting from coldfusion10 enterprise edition to oracle 12c database

  • February 10, 2017
  • 1 reply
  • 338 views

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..

This topic has been closed for replies.

1 reply

Inspiring
February 10, 2017

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