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.