Highlighted

CF11 and CF2016: can you use ref cursors with Oracle ojdbc drivers (not DataDirect)?

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?

Views

171

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

CF11 and CF2016: can you use ref cursors with Oracle ojdbc drivers (not DataDirect)?

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?

Views

172

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