Bug: Types with collections breaks code completion

[dimensions]

Hi there,

I think I have found a bug with the code parser. If I create the following package

CREATE OR REPLACE PACKAGE TESTPACKAGE AS

TYPE columnTable IS TABLE OF user_tab_cols%ROWTYPE INDEX BY BINARY_INTEGER;
TYPE tableRecord IS RECORD (details user_tables%ROWTYPE,cols columntable);

FUNCTION testmethod(
pDummy VARCHAR2
) RETURN tablerecord;

END TESTPACKAGE;
/

CREATE OR REPLACE PACKAGE BODY TESTPACKAGE AS

FUNCTION testmethod(
pDummy VARCHAR2
) RETURN tablerecord
IS
lrecord tablerecord;
BEGIN
RETURN lrecord;
END testmethod;

END TESTPACKAGE;
/

then code completion fails on my system for the function testmethod. If you then remove the member data "cols" from the tablerecord record then code completion starts working again.

Hopefully this provides a simple and repeatable enough test case for you to improve the code parser to handle these situations.

Thanks

Tom

 

[Marco Kalter]

You're right, the Code Assistant does not work if the cols field is included in the record type. We'll fix it.

 

[dimensions]

Glad to be of help finding bugs....it's a lovely product.

Any ideas of a timescale for a fix on this one....I've so used to code completion now I've got really lazy and the thought of actually typing the code myself isn't pleasant!!

Thanks

Tom

 

[Marco Kalter]

It will probably be incorporated in the next major release. We have no plans for additional 6.0 patch releases beyond the upcoming 6.0.6 version.