Post the full versions you are using of sql developer, ojdbc jar file and Oracle db.
Oracle Database 11g Enterprise Edition Release 184.108.40.206.0
SQL Developer Version 220.127.116.11 and Version 3.2.20.09 (same error for both)
Thanks for the info.
The 'Oracle SQL Developer 3.0: Overview and New Features' says that associative arrays are supported for unit tests:
Support added for abstract data types
PL/SQL Nested Table
PL/SQL Associative Array
I can't find any example that demonstrates that support nor do I understand how they might have implemented that support.
PL/SQL types are not accessible by SQL so you can only create or reference them from PL/SQL. So the only way I know of to test a procedure that has one of those as a parameter is to write a wrapper procedure that creates the proper collection type and then calls the procedure you want to test.
Is it possible to use the unit test framework for procedures / functions that take a table as a parameter?
Can we assume you know that your 'INDEXED BY' type is NOT a 'table'? It is an associate array.
You can certainly test using SQL types such as a nested table. But sql developer is still lacking some basic functionality in the unit test area, such as the ability to capture/display any DBMS_OUTPUT.
Afraid you will need to wait for one of the SQL DEV team to respond to your thread. I suggest you edit your thread subject to specifically include ASSOCIATE ARRAY; maybe that will get their attention.
reproducible, and log one bug for tracking
Let's wait for developer's reply
SQL Developer QA Team