CREATE OR REPLACE  PACKAGE my_pack AS
    TYPE customer_cursor IS REF CURSOR RETURN customer%ROWTYPE;
    TYPE order_cursor IS REF CURSOR RETURN orders%ROWTYPE;
    PROCEDURE my_proc (rc1 IN OUT customer_cursor, rc2 IN OUT
order_cursor);
END my_pack;

CREATE OR REPLACE PACKAGE BODY my_pack AS
    PROCEDURE my_proc(rc1 IN OUT customer_cursor, rc2 IN OUT
order_cursor) IS
        BEGIN
            OPEN rc1 FOR SELECT * FROM customer;
            OPEN rc2 FOR SELECT * FROM ORDER;
        END my_proc;
END my_pack;