<div>
No I hadn't, thanks. &nbsp;I suppose then the other question here is, &nbsp;can I use the MS SQL stored proc style where I just issue some select at the end of my proc and get back the appropriate rows/columns?
</div>


No I hadn't, thanks.  I suppose then the other question here is,  can I use the MS SQL stored proc style where I just issue some select at the end of my proc and get back the appropriate rows/columns?

<div>
<div class="content wysiwyg-content">
Cold Fusion does not seem to like Ref Cursors. &nbsp;I have looked at converting a stored procedure to not needing a ref cursor for output but not found the method to make the change.<br />
<br />
Can any suggest either how to handle a ref cursor in cold fusion, &nbsp;or how to change an Oracle stored procedure to return the rows from a select statement without needing one?
</div>
</div>


Cold Fusion does not seem to like Ref Cursors.  I have looked at converting a stored procedure to not needing a ref cursor for output but not found the method to make the change.

Can any suggest either how to handle a ref cursor in cold fusion,  or how to change an Oracle stored procedure to return the rows from a select statement without needing one?

Cold Fusion Oracle Stored Procedures with Ref Cursor

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.