Breakpoint conditions and messages

Bo Pedersen

Member²
When setting a conditional breakpoint, the condition can reference PL/SQL variables using the bind variable syntax, i.e. :p_emp_no. A great feature :cool:

But when defining a breakpoint message the whole message seems to be interpreted as a text. I think it would be a nice feature to also support bind variables here. The corresponding use of dbms_output often includes writting variable values. Beside not altering the code, the breakpoint messages also have the advantage that they are displayed immediately. I.e. when stopping at a breakpoint it is possible to see all breakpoint messages that have occured prior to the breakpoint.

Bo Pedersen
 
Back
Top