Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

In the left pane, double-click Procedures & Functions.

Select a procedure.

Choose Mode » Debug.

In the Which User Would You Like To Debug field, type * to debug all users, or type the name of the database user you want to debug.

In the right pane, click the line where you want to insert the breakpoint.

A cursor appears in the line where you clicked.

Press F9.

A red circle appears to the left of the line of code.

Choose Debug » Breakpoints.

Click New.

In the Procedure list, select a procedure.

If required, complete the Condition and Count fields.

The Condition is a SQL expression that must evaluate to true for the breakpoint to interrupt execution. For example, you can set a breakpoint to apply to a connection made by a specified user, by entering the following condition:

CURRENT USER = 'user-name'

The Count is the number of times the breakpoint is hit before it stops execution. A value of 0 means that the breakpoint always stops execution.

Click OK. The breakpoint is set on the first executable statement in the procedure.