I just started using QCTO and it looks great. I noticed something weird, though.
When I have a Packaged Function the Builder is under the assumption that it is a procedure.
When it is a stand-alone function, the Program Selector sees it as a Function, but the Builder still thinks it is a Procedure.
This only happens when the return type is anchored to a table.
Here is my test code:
SQL> create table t
2 (x int
3 ,value varchar2(10)
SQL> create package alx_pkg
3 function get_value (p_id in number)
4 return t.value%type;
SQL> create or replace function get_value (p_id in number)
2 return t.value%type
5 return null;