PL/SQL (MOSC)

MOSC Banner

Using DBMS_JOB.SUBMIT for Procedures with "OUT" Parameters

edited Mar 1, 2019 1:05AM in PL/SQL (MOSC) 5 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center