Highlighted

Will CF2016 allow Oracle ojdbc drivers to work with REF CURSOR ( cfprocresult) ?

New Here ,
Mar 22, 2017

Copy link to clipboard

Copied

Will newer versions of CF (cf11 or CF2016) allow you to use Oracle's ojdbc thin drivers (12g) along with REF CURSOR? I know ojdbc drivers did not allow CF ref cursors in older versions... We must use ojdbc drivers:

The Oracle JDBC thin driver oracle.jdbc.thin works fine with proxy authentication. But doesn't work with stored procedure REF CURSOR parameters. The ColdFusion documentation for cfprocresult states "You cannot use [REF CURSORS] with Oracle’s ThinClient JDBC drivers." Is this statement up-tod-date? Does it apply to the current v11/12 Oracle JDBC driver? Is there any workaround that allows REF CURSOR parameters?

TOPICS
Advanced techniques

Views

291

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Will CF2016 allow Oracle ojdbc drivers to work with REF CURSOR ( cfprocresult) ?

New Here ,
Mar 22, 2017

Copy link to clipboard

Copied

Will newer versions of CF (cf11 or CF2016) allow you to use Oracle's ojdbc thin drivers (12g) along with REF CURSOR? I know ojdbc drivers did not allow CF ref cursors in older versions... We must use ojdbc drivers:

The Oracle JDBC thin driver oracle.jdbc.thin works fine with proxy authentication. But doesn't work with stored procedure REF CURSOR parameters. The ColdFusion documentation for cfprocresult states "You cannot use [REF CURSORS] with Oracle’s ThinClient JDBC drivers." Is this statement up-tod-date? Does it apply to the current v11/12 Oracle JDBC driver? Is there any workaround that allows REF CURSOR parameters?

TOPICS
Advanced techniques

Views

292

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 22, 2017 0

Have something to add?

Join the conversation