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
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: