Oracle 5.0, Reference Manual

Page: 1867 / 3232

Connector/Net Visual Studio Integration
1847
Figure 20.28. Expressions and Breakpoints
• To define pass count breakpoints, after creating the breakpoint, right click in the red dot and choose
Hit Count.... In the popup dialog, define the specific condition to set. For example, break when the
hit count is equal to and a value 3 will trigger the breakpoint the third time it is hit.
Other Features
• To abort the debug session (and the execution of the current call stack of routines), press Shift+F5.
• To run the routine to completion (or until next breakpoint hit), press F5.
• For all functionality you can use (in addition to the shortcuts documented), see the options in the
Debug menu of Visual Studio.
Limitations
• Code being debugged must not use
get_lock
or
release_lock
MySQL functions, since they
are used internally by the debugger infrastructure to synchronize the debugger and the debugged
routine.
• Code being debugged must avoid using any transaction code (
START TRANSACTION
,
COMMIT
,
ROLLBACK
) due to the possibility of wiping out the contents of the debugger tables. (This limitation
may be removed in the future).
• You cannot debug the routines in the
serversidedebugger
database.
• The MySQL server running the routine being debugged can be any version between 5.0 and 5.6,
running on Windows, Linux, or any other supported platform.
• We recommend always running debug sessions on test and development servers, rather than
against a MySQL production server, because debugging can cause temporary performance issues
or even deadlocks. The instrumented versions of the routines being debugged use locks, that the
rest of the production code may not be aware of.