Code Assistant

[S. Studeny]

Hi.

Code Assistant is not able to assist inside package body with pl/sql type defined in package specification.

If you want to write procedure proc1 below and use assistant to supply param1 type, it will not work.

TEST PACKAGE:

create or replace package pkg_test is

type t_row is record (
per_id number,
orgunitid number
);
type t_tab is table of t_row;

end;
/
create or replace package body pkg_test is

procedure proc1 (param1 t_tab) is
begin
null;
end;

end;
/

It is bug or missing feature in PL/SQL Dev. 10?

Best Regards,
Stanislav

 

[Marco Kalter]

This is indeed a restriction of the Code Assistant. It cannot describe collection items.

 

[S. Studeny]

Hi, yes. You are right, but i mean only "t_row" or "t_tab" .. not the collection element like t_tab(something).per_id. When i write "t_" it should allow me to add t_row or t_tab as defined in pkg spec.

The structure is allready known as can be seen from this image.

Regards,
Stanislav

 

[Marco Kalter]

I see. This does indeed only work for locally declared variables and types.