When I login into some schema through code tester for oracle, I am not able to view the TYPEs which are defined as TABLE OF some data type or record. e.g . CREATE OR REPLACE TYPE “COLTYPE_ID” IS TABLE OF NUMBER(10).
If any input/output variables are used having such data types then I can not run the particular procedure/function as it gives ORA ERROR: ORA-00931: missing identifier.
Please let me, whether there is some setting for that or it is the limitation of current version(2.6.1) of code tester tool.
Due to this problem I can not dare to switch over to code tester from utPLSQ.
Thanks and regards,