SQL Developer for VS Code

When passing a clob into a procedure as an input parameter during a debug session, the clob is not being handled correctly by the extension.

DB Version: Oracle 19c Production

Sample Program:

create or replace PROCEDURE CURSOR_DBG_TEST ( 
P_INPUT IN VARCHAR2 
,P_IN_CLOB IN CLOB 
,P_OUT_CUR OUT SYS_REFCURSOR 
) 
IS 
BEGIN 
DBMS_OUTPUT.PUT_LINE(DBMS_LOB.GETLENGTH(P_IN_CLOB)); 

OPEN P_OUT_CUR 
FOR 
SELECT * 
FROM SYS.ALL_TABLES 
WHERE OWNER = 'SYS' 
AND status = P_INPUT; 

DBMS_OUTPUT.PUT_LINE('END'); 
END CURSOR_DBG_TEST;

Debug Screen:

View PL/SQL Result

Error Upon Clicking Debug

  P_IN_CLOB := SOME VALUE HERE;

                    *

ERROR at line 7:

ORA-06550: line 7, column 21:

PLS-00103: Encountered the symbol "VALUE" when expecting one of the following:



   . ( * @ % & = - + ; < / > at in is mod remainder not rem

   <an exponent (**)> <> or != or ~= >= <= <> and or like like2

   like4 likec between || multiset member submultiset

The symbol ". was inserted before "VALUE" to continue.



https://docs.oracle.com/error-help/db/ora-06550/





More Details :

https://docs.oracle.com/error-help/db/ora-06550/

https://docs.oracle.com/error-help/db/pls-00103/

Classic/Legacy Behaviour

You cannot edit in the Input value up top but you can edit the PL/SQL block before running and ensure its TO_CLOB('xxxxx')

Result of same program from Classic

Connecting to the database PSOLT - pview proxy.
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '###.###.###.###', '4000' )
Debugger accepted connection from database on port 4000.
Source breakpoint: CURSOR_DBG_TEST.pls:7
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.DISCONNECT()
15
END
Process exited.
Disconnecting from the database PSOLT - pview proxy.
Debugger disconnected from database.