How to print large output from PL/SQL
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
0