This example shows how to debug a package in dbForge Studio for Oracle. Use provided scripts to create sample objects in your test database.
Use the script available in How To: Debug a Stored Procedure to the procedure used in the sample below.
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:
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.