Oracle PL/SQL: How to print a table type
oracle, plsql
Solution
dbms_output.put_line(v_temp_tabtype(i).myString);
Problem
I am trying to print an `table type` for debugging purposes, but don't know how. I tried the following two methods, neither of which work: ``` dbms_output.put_line (V_TEMP_TABTYPE(1)); dbms_output.put_line (V_TEMP_TABTYPE); ``` The error generated is: `PLS-00306: wrong number or types of arguments in call to`. So, how can I print the contents of a `table type`? Or is there a different way to display the contents? The `table_type` and the `type` it references are:: ``` create or replace TYPE MY_TYPE IS OBJECT( MyString Varchar(20) , counter Number(9) ); create or replace TYPE MY_TABTYPE AS TABLE OF MY_TYPE; ```