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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Passing Cursor to Stored Procedure
Thanks for the reply Mufasa. Unfortunately, I have to pass a cursor to the stored procedure because I am also using the stored procedure to return results to an ASP.NET program. Using the cursor for returning results to ASP.NET works great. I just can't seem to make use of it within another...- doctorfly
- Post #3
- Forum: Oracle: All versions
-
Passing Cursor to Stored Procedure
Hi, Does anyone know how to create a procedure that calls another procedure with a cursor and then uses that cursor in a loop? procedure SP_ASSIGN_HOUSING AS myHousingRankingCursor HOUSINGTYPES.HOUSING_CURSOR; BEGIN /* call SP with cursor */ SP_GET_HOUSING_LIST(myHousingRankingCursor); /*...- doctorfly
- Thread
- Replies: 3
- Forum: Oracle: All versions
