Developing Applications Running on SAP BTP Using SAP HANA Cloud

Debugging SQLScript

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Debug SQLScript using the DB Explorer

Debugging SQLScript

Watch this video to learn how to debug a stored Procedure.

Process Flow to Debug a Stored Procedure

To use the SQLScript debugger, proceed as follows: Open database Explorer.

  1. To open the debug panel, choose the Debugger icon on the right side of the screen.
  2. Use the Attach Debugger icon (plug icon next to the Active Session dropdown box) to link the debugger to your session.
  3. Specify the debug target which is the database connection you want to use and confirm by selecting OK.

    You will see a success message appear in the upper right corner of the DB Explorer.

  4. Open the procedure for debugging from the context menu: Context MenuOpen for Debugging.
  5. Set breakpoints by clicking the line numbers.
  6. From the Context Menu of the procedure use the Generate CALL Statement
  7. Execute the Procedure
  8. Use the controls in the Debugger panel to Resume, Step Over, Step In, or Step Out.

Debugging SQLScript

Debugging SQLScript

Exercise

Debugging SQLScript

Start Exercise

Save progress to your learning plan by logging in or creating an account