Phoenix - Your AI AssistantOracle PL/SQL Development & Packages
Delivery in
4 days
- Views 1
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will develop up to 3 Oracle PL/SQL stored procedures, functions, or package units — covering parameterised input handling, EXCEPTION handling with RAISE_APPLICATION_ERROR, autonomous transaction logging, cursor management, bulk collect and FORALL for batch processing efficiency, and comprehensive unit testing. PL/SQL written without proper EXCEPTION handling allows errors to propagate silently or with uninformative error messages; PL/SQL written with row-by-row cursor loops instead of bulk collect and FORALL processes large datasets orders of magnitude more slowly than necessary.
Each object covers package specification and body structure (for package development), parameter mode (IN, OUT, IN OUT) with appropriate data types, EXCEPTION block with WHEN OTHERS and specific exception handlers, autonomous transaction pragma for logging, BULK COLLECT with FORALL for batch DML, and a unit test script covering normal and error execution paths.
Designed for Oracle development teams and businesses who need PL/SQL objects built to production quality standards with proper error handling and performance optimisation.
Each object covers package specification and body structure (for package development), parameter mode (IN, OUT, IN OUT) with appropriate data types, EXCEPTION block with WHEN OTHERS and specific exception handlers, autonomous transaction pragma for logging, BULK COLLECT with FORALL for batch DML, and a unit test script covering normal and error execution paths.
Designed for Oracle development teams and businesses who need PL/SQL objects built to production quality standards with proper error handling and performance optimisation.
What the Freelancer needs to start the work
Please provide functional specifications for each object, your relevant table schemas, your Oracle version, access to a development schema for testing, and any existing PL/SQL code I should build on or replace.