Do I have any possibility to use package defined collection/non scalar types except plain PL/SQL tables (varray, nested tables, records) defined in my package? When I tried to use TOracleObject the error was generated by OciDescribeAnyType that type was not found. Does it mean that I can use only globally defined types?
I know that there is a way to use PL/SQL block like that
declare
-- Local variables here
j my_package.My_Tab;
begin
-- Test statements here
j(1) := :first;
j(2) := :second;
end;
But with quite a huge and complicated type with different non scalar subtypes it's gonna bee quite a pain to bound ALL variables thru SetVariable. Indeed there is no way to make TOracleObject do this?
I know that there is a way to use PL/SQL block like that
declare
-- Local variables here
j my_package.My_Tab;
begin
-- Test statements here
j(1) := :first;
j(2) := :second;
end;
But with quite a huge and complicated type with different non scalar subtypes it's gonna bee quite a pain to bound ALL variables thru SetVariable. Indeed there is no way to make TOracleObject do this?
