Using DBMS_JOB.SUBMIT for Procedures with "OUT" Parameters
Hi Experts,
I have the following Package specification
CREATE OR REPLACE PACKAGE xx_test AS
TYPE t_lines IS RECORD ( sold_to_org_id oe_order_headers_all.sold_to_org_id%TYPE,
transactional_curr_code oe_order_headers_all.transactional_curr_code%TYPE,
line_id oe_order_lines_all.line_id%TYPE,
order_number oe_order_headers_all.order_number%TYPE,
line_amount NUMBER
);
TYPE t_list_lines IS
TABLE OF t_lines INDEX BY BINARY_INTEGER;
PROCEDURE process_candidates (
p_list_candidates IN t_list_lines,
g_conc_request_id IN NUMBER,
p_completed_activities IN OUT NUMBER,