PL/SQL (MOSC)

MOSC Banner

How to print large output from PL/SQL

edited Oct 24, 2013 11:31AM in PL/SQL (MOSC) 11 commentsAnswered
I have a piece of unfinished PL/SQL as shown below. data_row is a cursor variable. MY_SP opens and returns cursor data_row (other input variables are omitted for simpleness). I wants to display the content of data_row on my screen. So I bulk fetch the cursor into a table type out_pt_tbl1. Now my question is how to display/output out_pt_tbl1. I am think of something like SELECT * FROM TABLE(out_pt_tbl1), but it does not work. I also thought of row fetch and DBMS_OUTPUT.PUT_LINE in a loop, but each row has many columns of different data type. It's hard to format the output

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