В запрос сам добавляется символ ":" (работаю в toad)

SELECT MAX (CASE WHEN col_nr = 1 THEN TRIM (number_val) END ) a1
                     , MAX (CASE WHEN col_nr = 2 THEN TRIM (string_val) END ) a2
                     , MAX (CASE WHEN col_nr = 3 THEN TRIM (string_val) END ) a3
                     , MAX (CASE WHEN col_nr = 4 THEN TRIM (number_val) END ) a4
                     , MAX (CASE WHEN col_nr = 5 THEN TRIM (string_val) END ) a5
                     FROM TABLE (gasedit.up_diag_eo.read(gasedit.up_diag_eo.getthis('\\100701s\www\wei.xlsx')))
                    WHERE row_nr > 2
                    GROUP BY row_nr ;

/* Formatted on 03.08.2015 17:22:57 (QP5 v5.185.11230.41888) */
  SELECT MAX (CASE WHEN col_nr = 1 THEN TRIM (number_val) END) a1,
         MAX (CASE WHEN col_nr = 2 THEN TRIM (string_val) END) a2,
         MAX (CASE WHEN col_nr = 3 THEN TRIM (string_val) END) a3,
         MAX (CASE WHEN col_nr = 4 THEN TRIM (number_val) END) a4,
         MAX (CASE WHEN col_nr = 5 THEN TRIM (string_val) END) a5
    FROM TABLE (
            gasedit.up_diag_eo.read (
               gasedit.up_diag_eo.getthis ('\\100701s\www\wei.xlsx')))
   WHERE :row_nr > 2
GROUP BY row_nr

DECLARE :row_nr  NUMBER := :row_nr;
BEGIN
"твой код"
END;