- Jay Hastings
- PowerServer
- Tuesday, 9 January 2024 12:50 AM UTC
I have multiple datawaindows that call Oracle stored procedures. Each one returns only ONE result set.
Within the stored procedure they may use temp tables and/or cursors to loop through the temp tables. Some are defined cursors (CURSOR c1_TempCursor IS...OPEN c1_TempCursor LOOP) and some may be inline cursors ( For c1_TempCursor in (Select blah blah blah) LOOP).
Either way I get
I cant' find anything on this. Are there limitations as to the inside of a stored procedure? I can understand the returned result set.
Any ideas/recommendations?
Thanks in advance
Jay
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.