Using debug session to manually get variable values

[mpapec2010]

After I start a debug session, I want to execute sql in debug session in order to obtain value by hand.
Is that possible?

I was using this, which ends up in error (xec is always 28).

declare
  xec  binary_integer;
  buff  varchar2(2000);
begin
  xec := dbms_debug.get_value('varname', 0, buff);

end;

Is there something wrong in this picture?
Tnx

 

[Marco Kalter]

This is indeed not possible. The dbms_debug.get_value function can only be called from the controlling session, to which you do not have access. You can only obtain variable values through the normal PL/SQL Developer debugger functions. You can also execute SQL code within the debug session when execution is paused through the "Execute SQL in debug session" button on the debugger toolbar.

 

[mpapec2010]

You can also execute SQL code within the debug session when execution is paused through the "Execute SQL in debug session" button on the debugger toolbar.

So "executing in debug session" executes a query in target, rather than debug session?

 

[Marco Kalter]

It executes a SQL command or PL/SQL Block in the session that runs the program that you are debugging.

 

[mpapec2010]

It executes a SQL command or PL/SQL Block in the session that runs the program that you are debugging.

Oh, I see; Oracle docs use a bit different terminology.

To debug server-side code, you must have two database sessions: one session to run the code in debug mode (the target session), and a second session to supervise the target session (the debug session).

https://docs.oracle.com/database/121/ARPLS/d_debug.htm#ARPLS66093