Code Assist: Object Type instances

Toad for Oracle - Beta
1

Since Code Assist seems to have improved a lot over the last years, I dare to ask if support for Object Type instances is planned.

Most of the required information seems to be available (Navigator, existing Code Assist for Object Types), so I hope there might be a way to support Object Type instances too.

Below are some examples that came to my mind. Thanks!

CREATE OR REPLACE TYPE t_type AS OBJECT (
something VARCHAR2(10),
MEMBER FUNCTION get_something RETURN VARCHAR2,
STATIC FUNCTION get_something_static RETURN PLS_INTEGER
);

DECLARE
TYPE t_record IS RECORD(
something PLS_INTEGER,
type_member t_type
);

v_type t_type;
v_record t_record;
v_desc_rec dbms_sql.desc_rec;
v_desc_tab dbms_sql.desc_tab;
BEGIN
– Already works! (no need to show non-static members though)
dbms_output.put_line( t_type.get_something_static() );

dbms_output.put_line( v_type.something );
dbms_output.put_line( v_type.get_something() );

dbms_output.put_line( v_record.something );
dbms_output.put_line( v_record.type_member.something );

dbms_output.put_line( v_desc_rec.col_type );
dbms_output.put_line( v_desc_tab(1).col_type );
END;

2

It’s too late for this release, but I’ll log this. Yeah, we have all of the information readily available it’s just a matter of extracting and showing it to you.

3

Great, I’m really looking forward to this! Hope you’ll be able to get it into the next release.

I guess that ROWTYPEs are similar, so I’m suggesting them too:

DECLARE
v_row dual%ROWTYPE;
BEGIN
dbms_output.put_line( v_row.
END;

4

ROWTYPE request is logged as well.

5

This is now almost five years old and I'm still missing this feature :slight_smile:

Any chance of getting it on a roadmap?

6

It's not on the roadmap, but it is on the radar. Several Code Insight deficiencies have come up during backlog review meetings we've been having for some weeks now. We will be discussing these in more detail as we refine.

1 Like