SQL> select (1, 2) from dual;
select (1, 2) from dual
         *
ERROR at line 1:
ORA-00907: missing right parenthesis

SQL> select 1, 2 from dual;

         1          2
---------- ----------
         1          2

CREATE OR replace PACKAGE BODY pkg_upload_batches 
AS 
  PROCEDURE Usp_batches_insert (batch_sequence_id   IN NUMBER, 
                                status              IN VARCHAR2, 
                                package_sequence_id IN NUMBER, 
                                is_activated        IN VARCHAR2, 
                                modified_by         NUMBER, 
                                modified_date       IN DATE, 
                                resultset           IN OUT SYS_REFCURSOR) 
  AS 
  BEGIN 
  /* TODO implementation required */ 
      --select ICCIDS from (SYS.dbms_debug_vc2coll ICCID_LIST) 
      merge INTO dep_batch_details n 
      USING dep_iccid_temp o 
      ON ( n.dbd_iccid = o.dbd_iccid ) 
      WHEN NOT matched THEN 
        INSERT (dbd_iccid, 
                dbd_isactivated, 
                dbd_modified_by, 
                dbd_modified_on, 
                dbd_status, 
                dbh_seq, 
                dpg_seq ) 
        VALUES ( o.dbd_iccid, 
                 is_activated, 
                 modified_by, 
                 modified_date, 
                 status, 
                 batch_sequence_id, 
                 package_sequence_id ); 

      COMMIT; 
  END; 
END pkg_upload_batches;