What do the options stand for in the output options in the Set Parameter window when debugging?
Output Options in the Set Parameter window:
1] Print OUT arguments/RETURN values to DBMS Output
This option controls all printable datatypes other than ref cursors.
2] Print to DBMS Output (char/number columns only)
Checking this will generate code to fetch data from the ref cursor and print it to DBMS output one row per line. A header row is also printed showing the column names.
Note: DBMS_output_print_line() will raise an exception if a line is more than 255 characters long. This option will only print values of char/number datatypes. For other datatypes, the name of the datatype is printed in square brackets.
3] RPAD columns to a width of N characters
This option allows simple formatting of output. Checking this will modify the generated code to apply the RPAD() function to all values printed to DBMS output, passing the user-specified width. This will not only right-pad values with spaces, but also truncate values longer than the given width. It is also applied to the column names.
4] Create and write to table (DROP existing table)
This option generates code to create a table (in the current schema) based on the ref cursor's record type, and insert the fetched data into it. The table is given a name like Toad_DEBUG_SOME_RC where SOME_RC is the name given to the ref cursor in code.
Note: This does not work for tables with a storage table, nor does it handle VARCHAR2(n CHAR) columns. They are declared as VARCHAR2(n).
5] Fetch no more than N rows per cursor
Limits the number of rows fetched. Applies to both DBMS output and table options.
