Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 839
  • 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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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