Minor oddity with TOAD 12.8.0.49 code analysis and certain VARRAY

Toad for Oracle & DevOps Toolkit
1

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

2

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.

3

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

4

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.