Executing a Procedure in Studio
When you execute a procedure in Studio, you have the option (with SQL scripts and parameterized queries) to use the Trace button to see line-by-line execution details. If input parameter values are required for the procedure, a window opens with the parameter names and fields for you to type the values before execution proceeds.
To execute a procedure in Studio
1. Open the procedure.
2. If you want to see line-by-line execution details, set the Trace button.
3. Click the Execute button.
4. If input parameter values are required, supply those values and click 0K.
5. Execute the procedure.
6. Review the execution details for each line are shown in the Console tab.
7. You can cause debug messages to be posted to the console or log by calling print, log, or logError.