This example shows how to debug a package in dbForge Fusion for Oracle. Use provided scripts to create sample objects in your test database.
Procedure
Use the script available in How To: Debug a Stored Procedure to the procedure used in the sample below.
Package
Use the script below to create the IU_Schedule_Detail package:
-- PACKAGE_SCHEDULE specification
CREATE OR REPLACE PACKAGE SCHEDULE.Package_Schedule AS
PROCEDURE FILLSCHEDULE(DATE_FROM IN DATE, DATE_TO IN DATE,SCHEDULE_ID IN INT);
FUNCTION GetFirstDayOfMonth(DT DATE) RETURN DATE;
END Package_Schedule;
/
To debug a package:
Note
You can also debug a package from other PL/SQL programs, which call package procedures or functions using the same way for schema procedures and functions debugging.