Solved

Cold Fusion Oracle Stored Procedures with Ref Cursor

Posted on 2010-08-19
3
788 Views
Last Modified: 2013-12-19
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?
0
Comment
Question by:hbash
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
parikaa earned 500 total points
ID: 33480129
0
 
LVL 1

Author Comment

by:hbash
ID: 33481766
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?
0
 
LVL 5

Assisted Solution

by:parikaa
parikaa earned 500 total points
ID: 33481844
I believe for every stored procedure you have you need to put a definition in either one or many reference cursors and the stored proc in the corresponding package. At least that's the way I have alway accomplished calling stored procs from an oracle db.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Getting network error using utl tcp package 7 83
oracle query 15 63
oracle rollup query 3 37
Problem with data displaying 2 11
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now