Skip to Main Content
Forums

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!

25.3.0 Debugger will not attach

DataProcessing6 hours ago

VsCode
Version: 1.105.0 (user setup)
Commit: 03c265b1adee71ac88f833e065f7bb956b60550a
Date: 2025-10-08T14:09:35.891Z
Electron: 37.6.0
ElectronBuildId: 12502201
Chromium: 138.0.7204.251
Node.js: 22.19.0
V8: 13.8.258.32-electron.0
OS: Windows_NT x64 10.0.26100 - Windows 11

Open Debug Runner, click Debug button. Two error pop-up messages appear. Debugger WILL NOT ATTACH. SCRIPT_OUTPUT panel shows the execution results.

SQL> -- runner for NEO.PK_DEBUG_DEMO
SQL> SET SERVEROUTPUT ON
SQL> 
SQL> DECLARE
  2    N_NUMBER_IN NUMBER;
  3  BEGIN
  4    N_NUMBER_IN := NULL;
  5    NEO.PK_DEBUG_DEMO.P_PARAMETER_ASSIGNMENT(
  6      N_NUMBER_IN => N_NUMBER_IN);
  7    -- Rollback;
  8  end;

n_number_in IS NULL

PL/SQL procedure successfully completed.
Elapsed: 00:00:00.035

Sample Code

create or replace package pk_debug_demo 
authid current_user
is
   procedure p_parameter_assignment( n_number_in in number );   
end;
/
create or replace package body pk_debug_demo 
is
   procedure p_parameter_assignment( n_number_in in number ) is
   begin
      sys.dbms_output.enable();
      if n_number_in is null then
         sys.dbms_output.put_line('n_number_in IS NULL');
      else 
         sys.dbms_output.put_line('n_number_in '||n_number_in);
      end if;
   end;
end;
/

[10/10/25, 20:17:42.112] [Connections Navigator] [INFO ] Action details
{
"action": "Connect",
"message": "Connected",
"connection": {
"name": "NEO",
"href": "http://localhost:60412/20221610/databases/connections/definitions/IYC2lG-49AfhaKgN1csw8g"
},
"session": "http://localhost:60412/20221610/databases/connections/sessions/dbacilNQP_5sMuBhJ9PeBg/"
}
[10/10/25, 20:17:58.245] [Worksheet ] [INFO ] Action details
{
"action": "Attach",
"message": "Attached",
"connection": {
"name": "NEO"
},
"session": "http://localhost:60412/20221610/databases/connections/sessions/dbacilNQP_5sMuBhJ9PeBg/",
"worksheet": {
"uri": "/NEO/object/NEO/PACKAGE/PK_DEBUG_DEMO.pks"
}
}
[10/10/25, 20:17:59.736] [Worksheet ] [INFO ] Action details
{
"action": "Attach",
"message": "Attached",
"connection": {
"name": "NEO"
},
"session": "http://localhost:60412/20221610/databases/connections/sessions/dbacilNQP_5sMuBhJ9PeBg/",
"worksheet": {
"uri": "/NEO/object/NEO/PACKAGE/PK_DEBUG_DEMO/PK_DEBUG_DEMO.pkb"
}
}
[10/10/25, 20:18:05.395] [Worksheet ] [INFO ] Action details
{
"action": "Attach",
"message": "Attached",
"connection": {
"name": "NEO"
},
"session": "http://localhost:60412/20221610/databases/connections/sessions/Ylmv9qzmqh0e5OwkSeMGSQ/",
"worksheet": {
"uri": "/NEO/object/NEO/PACKAGE/PK_DEBUG_DEMO/PK_DEBUG_DEMO.run"
}
}
[10/10/25, 20:18:21.904] [dbtools-client ] [INFO ] Debug Services connecting at http://localhost:60412/20221610/debug-server/socket
[10/10/25, 20:18:21.906] [dbtools-client ] [INFO ] Debug Services Websocket Created
[10/10/25, 20:18:21.947] [DBToolsServerApp(20744)] [ERROR] 2025-10-11T00:18:21.946Z ERROR java.lang.reflect.InvocationTargetException
java.lang.reflect.InvocationTargetException
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:118)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at com.oracle.dbtools.server.dap@25.3.0/com.oracle.dbtools.server.dap.DebugAdapter.handle(DebugAdapter.java:252)
at com.oracle.dbtools.server.dap@25.3.0/com.oracle.dbtools.server.dap.DebugServer.lambda$handle$1(DebugServer.java:184)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.Task.lambda$of$1(Task.java:94)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.lambda$accept$0(ErrorHandler.java:82)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.accept(ErrorHandler.java:88)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.accept(ErrorHandler.java:80)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.TaskRequest.lambda$execute$0(TaskRequest.java:162)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.lambda$accept$0(ErrorHandler.java:82)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.accept(ErrorHandler.java:88)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.accept(ErrorHandler.java:80)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.TaskExecutorImpl.executeOperation(TaskExecutorImpl.java:95)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.TaskRequest.execute(TaskRequest.java:158)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.TaskExecutorImpl.lambda$execute$0(TaskExecutorImpl.java:122)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.accept(ErrorHandler.java:47)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.TaskExecutorImpl.lambda$execute$1(TaskExecutorImpl.java:118)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.lang.IllegalArgumentException: untitled:Untitled-1
at com.oracle.dbtools.server.common.bridge@25.3.0/com.oracle.dbtools.server.common.bridge.sql.ObjectIdentifier.of(ObjectIdentifier.java:68)
at com.oracle.dbtools.server.dap@25.3.0/com.oracle.dbtools.server.dap.DebugAdapter.plsqlUnit(DebugAdapter.java:489)
at com.oracle.dbtools.server.dap@25.3.0/com.oracle.dbtools.server.dap.DebugAdapter.setBreakpoints(DebugAdapter.java:448)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
... 20 more
[10/10/25, 20:18:21.949] [DBToolsServerApp(20744)] [ERROR] 2025-10-11T00:18:21.948Z ERROR java.lang.reflect.InvocationTargetException
java.lang.reflect.InvocationTargetException
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:118)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at com.oracle.dbtools.server.dap@25.3.0/com.oracle.dbtools.server.dap.DebugAdapter.handle(DebugAdapter.java:252)
at com.oracle.dbtools.server.dap@25.3.0/com.oracle.dbtools.server.dap.DebugServer.lambda$handle$1(DebugServer.java:184)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.Task.lambda$of$1(Task.java:94)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.lambda$accept$0(ErrorHandler.java:82)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.accept(ErrorHandler.java:88)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.accept(ErrorHandler.java:80)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.TaskRequest.lambda$execute$0(TaskRequest.java:162)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.lambda$accept$0(ErrorHandler.java:82)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.accept(ErrorHandler.java:88)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.accept(ErrorHandler.java:80)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.TaskExecutorImpl.executeOperation(TaskExecutorImpl.java:95)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.TaskRequest.execute(TaskRequest.java:158)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.TaskExecutorImpl.lambda$execute$0(TaskExecutorImpl.java:122)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.ErrorHandler.accept(ErrorHandler.java:47)
at com.oracle.dbtools.utils.core@25.3.0/com.oracle.dbtools.utils.core.tasks.TaskExecutorImpl.lambda$execute$1(TaskExecutorImpl.java:118)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.lang.IllegalArgumentException: untitled:Untitled-3
at com.oracle.dbtools.server.common.bridge@25.3.0/com.oracle.dbtools.server.common.bridge.sql.ObjectIdentifier.of(ObjectIdentifier.java:68)
at com.oracle.dbtools.server.dap@25.3.0/com.oracle.dbtools.server.dap.DebugAdapter.plsqlUnit(DebugAdapter.java:489)
at com.oracle.dbtools.server.dap@25.3.0/com.oracle.dbtools.server.dap.DebugAdapter.setBreakpoints(DebugAdapter.java:448)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
... 20 more
Comments
Post Details
Added 6 hours ago
#debugger
0 comments
8 views