When running a procedure, the output is not displayed. The proc collects data with an output variable of user defined object type. The proc runs without errors, but nothing shows in DBMS output, or any other output window in Toad.
The correct output option is set in the Set Parameters window, set to "Print OUT arguments..."
The anonymous code block that gets generated gives a blank DBMS_OUTPUT.Put_Line('');.
Can Toad display an OUT variable that is of user defined object type?
DBMS_OUTPUT does not support a generic object type. DBMS will not know how to handle this, and since Toad works off of the DBMS, it can only do what Oracle's DBMS can handle. This is a Oracle limitation and Toad will not be able to display the output of object type.
The data should be collected, but to display, the code will need to be adjusted so that the data is put into another from that Oracle's DBMS can handle.
