VARRAYs defined in packages are not reachable with TOracleObject

[ulrich.brawand]

When defining a type in a package like

CREATE OR REPLACE package JOB_PCK is
TYPE T_VAR IS VARRAY(10) OF INTEGER;

Testing and debugging in TOAD 7.5 everything works fine.

With Package Wizard a generate the wrapper class with the line
Pl := TOracleObject.Create(Session, '"JOB_PCK"."T_VAR"', '');

Execution of the code gets error
ORA-40043: object "JOB_PCK"."T_VAR" does not exist

Defining T_VAR as a global type, everything works fine.

Regards, Ulrich

 

[Marco Kalter]

That is correct, packages types currently cannot be used through the TOracleObject class.

------------------
Marco Kalter
Allround Automations