?
Solved

Cold Fusion Oracle Stored Procedures with Ref Cursor

Posted on 2010-08-19
3
Medium Priority
?
819 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:Howard Bash
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Accepted Solution

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

Author Comment

by:Howard Bash
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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

764 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