Error EAssertionFailed while using collection params with TCustomOraPackage
Posted: Tue 30 May 2017 09:04
Hi, Team.
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
and procedure
When I execute this procedure I get EAssertionFailed in DBAccess.pas at line 17580 (but only in cases when I pass 2+ elements in collection).
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.
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.