-- Natural Language: "Create a package for managing customer orders"
CREATE OR REPLACE PACKAGE customer_order_mgmt AS
    -- Types
    TYPE order_details_rec IS RECORD (
        order_id    orders.order_id%TYPE,
        total_amount orders.total_amount%TYPE,
        status      orders.status%TYPE
    );
    
    -- Functions
    FUNCTION get_customer_orders(
        p_customer_id IN customers.customer_id%TYPE
    ) RETURN SYS_REFCURSOR;

    -- Procedures
    PROCEDURE create_order(
        p_customer_id  IN  customers.customer_id%TYPE,
        p_items        IN  order_items_table,
        p_order_id    OUT orders.order_id%TYPE
    );

    PROCEDURE update_order_status(
        p_order_id IN orders.order_id%TYPE,
        p_status   IN orders.status%TYPE
    );
END

-- Natural Language: "Generate error handling template for database operations"
CREATE OR REPLACE PACKAGE error_handling AS
    -- Custom exceptions
    e_validation_error EXCEPTION;
    PRAGMA EXCEPTION_INIT(e_validation_error, -20001);
    
    e_business_rule_violation EXCEPTION;
    PRAGMA EXCEPTION_INIT(e_business_rule_violation, -20002);

    -- Error handling procedures
    PROCEDURE log_error(
        p_error_code IN NUMBER,
        p_error_message IN VARCHAR2,
        p_procedure_name IN VARCHAR2,
        p_additional_info IN VARCHAR2 DEFAULT NULL
    );

    -- Get error message
    FUNCTION get_error_message(
        p_error_code IN NUMBER
    ) RETURN VARCHAR2;
END

-- Live execution environment
DECLARE
    v_result NUMBER;
    v_message VARCHAR2(200);
BEGIN
    v_result := your_package.your_function(param1, param2);
    DBMS_OUTPUT.PUT_LINE('Result: ' || v_result);
EXCEPTION
    WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('Error: ' || SQLERRM);
END

-- Debug mode with variable inspection
CREATE OR REPLACE PROCEDURE debug_procedure(
    p_input IN VARCHAR2
) AS
    v_debug BOOLEAN := TRUE;
BEGIN
    IF v_debug THEN
        DBMS_OUTPUT.PUT_LINE('Input parameter: ' || p_input);
    END IF;

    IF v_debug THEN
        DBMS_OUTPUT.PUT_LINE('Execution completed');
    END IF;
EXCEPTION
    WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('Error: ' || SQLERRM);
        RAISE;
END

-- Performance optimization suggestions
DECLARE
    v_start_time TIMESTAMP;
    v_end_time TIMESTAMP;
BEGIN
    v_start_time := SYSTIMESTAMP;
    -- Your code here
    v_end_time := SYSTIMESTAMP;
    DBMS_OUTPUT.PUT_LINE(
        'Execution time: ' || EXTRACT(SECOND FROM (v_end_time - v_start_time)) || ' seconds'
    );
END

-- Optimized bulk operations
CREATE OR REPLACE PROCEDURE bulk_update_example(
    p_data IN data_table_type
) AS
BEGIN
    FORALL i IN 1..p_data.COUNT
        UPDATE target_table
        SET column1 = p_data(i).value1,
            column2 = p_data(i).value2
        WHERE id = p_data(i).id;
    COMMIT;
END