Code completion for packages does not work in SQL Navigator 6.0 for use as a selection for a row-pipe-function.
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of SQL Navigator for Oracle.
Package is defined like:
CREATE OR REPLACE
PACKAGE a_pckg
IS
Type all_tab_type is table of tables%rowtype;
FUNCTION function_name
RETURN all_tab_type pipelined;
END; -- Package spec
/
CREATE OR REPLACE
PACKAGE BODY a_pckg
IS
FUNCTION function_name
RETURN all_tab_type pipelined
is
begin
for cur in (select * from tables) loop
pipe row(cur);
end loop;
return;
end;
END;
/
Now after trying to use this row-pipe-function in a select statement:
Select * from table(a_pckg. .... it is not completed.
In older version (up to 5.5) the behaviour was okay.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center