We using ODAC for quite time now and very satisfied with it, but after upgrade from version 9.7 to 10.0.2 we started to have a problem with using collections for params using TCustomOraPackage.
My package (wrapped with Oracle Package Wizard) contains pl/sql collection type
Code: Select all
type tl_number_coll is table of number index by binary_integer;
Code: Select all
procedure some_procedure
(
p_example_coll in tl_number_coll, -- some collection
p_example_flag in number, -- some flag
p_example_cursor out sys_refcursor -- result cursor
);
After some research I found the cause - in TDBAccessUtils.CheckArrayType not taken into account that TCustomOraPackage also has TOraParams field.
Would you like to suggest - what I can do with this problem (or make the fix - I would be much appreciated).
With best regards, Alexey.