When returning the output of SP in refcursor. How to view the output as a table instead of print refcursor; in Oracle?
Asked
Active
Viewed 791 times
0
Giftlin Rajaiah
- 11
- 4
-
if you run the package/procedure in sql developer (click on the green triangle), if you have the ref cursor as an out parameter, it will show as a table in the "output variables" tab, is that what you are asking? – Peter M May 04 '18 at 19:26
-
U mean F9? When I click on run, then it is printing in scripts. I want to view as table (like select * from table_name output) – Giftlin Rajaiah May 04 '18 at 19:39
-
ok -- maybe check out this link https://stackoverflow.com/questions/3556336/oracle-sql-developer-show-refcursor-results-in-grid – Peter M May 07 '18 at 16:51
1 Answers
0
Use the code editor in SQL Developer to execute the stored procedure. We'll grab the output for you - refcursors go to grids.
I talk about this in more detail here.
thatjeffsmith
- 20,522
- 6
- 37
- 120