object method intellisense

partial

Member
Can you make it so that the methods of an object type have intellisense for input parameters similar to the way a method in a package work?

For example:

CREATE OR REPLACE TYPE test AS OBJECT
(
test_id NUMBER,
MEMBER PROCEDURE print_text(p_txt IN VARCHAR2)
)

/

CREATE OR REPLACE TYPE BODY test IS

-- Member procedures and functions
MEMBER PROCEDURE print_text(p_txt IN VARCHAR2) IS
BEGIN
dbms_output.put_line(p_txt);
END;

END;

Then in a test procedure if you were to type "test.print_text(" after the "(" is pressed the procedure parameters would be listed.

A system view with this information is "All_Method_Params"

Thanks

 
Last edited:
Back
Top