thota198
asked on
enter the input parameter containing collection type
Hi folks
i have to set up the input parameter tht has collection type in it how can i enter the records in it
for i_quote_line_object_id IN cq_cbn_selection_tbl,
the script of cq_cbn_selection_tbl is
CREATE OR REPLACE TYPE DMADM.cq_cbn_selection_tbl IS TABLE OF cq_cbn_selection_obj
/
the script for cq_cbn_selection_obj is
CREATE OR REPLACE TYPE DMADM.cq_cbn_selection_obj AS OBJECT
(quote_line_object_id NUMBER, cbn_selection NUMBER)
/
parameters for i_quote_line_object_id are
i_quote_line_object_id: {[3716374545, 0],[3716374538, 0],[3716374535, 1],[3716374534, 0]}
i have to set up the input parameter tht has collection type in it how can i enter the records in it
for i_quote_line_object_id IN cq_cbn_selection_tbl,
the script of cq_cbn_selection_tbl is
CREATE OR REPLACE TYPE DMADM.cq_cbn_selection_tbl
/
the script for cq_cbn_selection_obj is
CREATE OR REPLACE TYPE DMADM.cq_cbn_selection_obj
(quote_line_object_id NUMBER, cbn_selection NUMBER)
/
parameters for i_quote_line_object_id are
i_quote_line_object_id: {[3716374545, 0],[3716374538, 0],[3716374535, 1],[3716374534, 0]}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER