The unit test supports only SQL types, no PL/SQL types. I can't find any reference to it in the documentation.
1 person found this helpful
While creating the Unit Test case for a procedure or a function involving a PL/SQL table as Input/output parameter, System throws an error "The return type table is not supported".
WHy is this so? Any pointers?
Only SQL types are publicly available. The only way Sql developer could support unit tests for code that uses PL/SQL types is to create a wrapper procedure in PL/SQL that populates the nested table and then calls the procedure being tested.
Try using a SQL type (CREATE OR REPLACE TYPE . . .) and see if your unit test works.