Hello,
I tend to make use of the some of the built-in MDSYS varray types in my code. For reasons unknown, the new TOAD 12.8.0.49 really hates any use of MDSYS.SDO_STRING2_ARRAY and marks it as “error… this variable has zero size”. It has no problem with other VARRAYs which is a bit weird. There does not seem to be a way to turn off this notification and is new behavior at 12.8.0.49. Its not a big deal but it does draw your eye as a distraction.
Thanks,
Paul
CREATE OR REPLACE PROCEDURE foo
AS
foo_array1 MDSYS.SDO_NUMBER_ARRAY;
foo_array2 MDSYS.SDO_STRING2_ARRAY;
foo_array3 MDSYS.SDO_NUMBER_ARRAY;
BEGIN
RETURN;
END foo;
/