Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 848
  • Last Modified:

Cold Fusion Oracle Stored Procedures with Ref Cursor

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
Howard Bash
Asked:
Howard Bash
  • 2
2 Solutions
 
parikaaCommented:
0
 
Howard BashSenior Software EngineerAuthor Commented:
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
 
parikaaCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now