I am trying to figure out how to write a stored procedure in Oracle that will return result sets that I can then use in ColdFusion using the CFPROC and CFPROCRESULT tags. This is sort of an Oracle question, but since the context I am trying to use in is ColdFusion, I thought there might be some ColdFusion gurus who have done this before. Can anyone help?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle Stored Procedure That Returns Result Sets
- Thread starter shammack
- Start date
engineer2100
Programmer
I think ORACLE Doesnot have the concept of returning Resultsets. It's only SQL Server that has this feature. Anyway I could have missed myself an update on this issue.Checkup before coming to a conclusion
- Status