Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Improvement in outline view

Are you going to improve outline view? In case of complicated packages it's not easy to navigate now. I miss internal cursors and functions/procedures. For package

CREATE OR REPLACE PACKAGE BODY TEST IS 
FUNCTION FF ( 
P_ID1 NUMBER, 
P_ID2 NUMBER 
) RETURN NUMBER IS 
CURSOR C1 IS 
SELECT 
* 
FROM 
EMPLOYEES E 
WHERE 
E.EMPLOYEE_ID = P_ID1; 
R1 C1%ROWTYPE; 

PROCEDURE PRINT( 
P_IN VARCHAR2 
) IS 
BEGIN 
DBMS_OUTPUT.PUT_LINE(P_IN); 
END PRINT; 

BEGIN 
OPEN C1; 
FETCH C2 INTO R1; 
CLOSE C1; 

return 1; 
END FF; 
END TEST; 
/

now in outline view there is no information about internal cursor and procedure

Deprecated extension shows them

Comments
Post Details
Added on Feb 3 2025
0 comments
72 views