Debugging Stored Function

This example shows how to debug a stored function in dbForge Fusion for Oracle. Use provided scripts to create sample objects in your test database.

Creating a Sample Function

Procedure

Use the script available in How To: Debug a Stored Procedure to the procedure used in the sample below.

Function

Use the script below to create the GetFirstDayOfMonth function that returns the first day of a calendar month

CREATE OR REPLACE FUNCTION GetFirstDayOfMonth(DT DATE)
  RETURN DATE
  AS
  BEGIN
    RETURN TRUNC(DT, 'MONTH');
  END;

Debugging Function

To debug the Oracle function:

  1. In Database Explorer, choose a test database.
  2. Click Procedures and then double-click the FILLSCHEDULE procedure to open it.
  3. Left-click in the gray margin next to the SELECT statement to insert a breakpoint in the place where we call the GetFirstDayOfMonth stored function.

    Breakpoint-for-function

  4. Click Start Debugging, and enter the input parameters values for the procedure.
  5. Add the DATE_TO variable to the Watches window. This option allows you to track the value of the variable while stepping through the code.

To add the variable to the Watches window, right-click the DT variable, and then select Add Watch from the shortcut menu. The variable will appear in the Watches window.

  1. Step through the code using the F11 key or the Step Into button to move directly to the breakpoint.

    Watches date

  2. Press F11 or click Step Into to get inside the GetFirstDayOfMonth stored function.

    Note

    You may ignore stepping through the function by clicking the Step Over button. In this case you will continue stepping through the stored procedure.

  3. Step through the GetFirstDayOfMonth function until you exit back to the stored procedure, and continue to the end.

    Procedure Code

    Procedure Code

Note

Place the mouse pointer over a variable to see its value.