PL/SQL (MOSC)

MOSC Banner

Fetching All Data from Sys_refcursor

edited Jul 24, 2020 2:19PM in PL/SQL (MOSC) 16 commentsAnswered

Greetings everyone,

I have been googling and searching, including in this community, for quite some time now and cannot find the answer.  I want to know, when executing a stored procedure that returns a sys_refcursor, how do I output all (rows and columns) of the data in it?  Do I need to use a loop? Can I output all of the data without having to loop through it?  Either way, I need details on how to take either approach.  I haven't seen anything where I can simply just output all of the data without using a loop.  The other instances, where a

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center