Link to home
Start Free TrialLog in
Avatar of thota198
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]}

ASKER CERTIFIED SOLUTION
Avatar of no worries :-) no nothing
no worries :-) no nothing
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thota198
thota198

ASKER

since the solution was not complete in the link so i have to give grade B