Toad World® Forums

Minor oddity with TOAD 12.8.0.49 code analysis and certain VARRAY

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;
/

That false syntax error is fixed in beta for 12.9.

On Jan 4, 2016, at 5:18 PM, Paul Dziemiela bounce-pdziemiela_781@toadworld.com wrote:

Minor oddity with TOAD 12.8.0.49 code analysis and certain VARRAY

Thread created by Paul Dziemiela
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;

/

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Thanks for the update!

So there is no way to “close” a given discussion? How does anyone keep track of what questions are answered or still open?

Cheers,

Paul

I’ve updated the post. Discussions cannot be closed, Questions can be marked as answered. Your post was created as a Discussion, but there’s an option when creating a post to mark it as a question and you can accept one or more replies as answers.