oracle

IF v_upnum LIKE '4008%'
      THEN
      SELECT length(rtrim(upnumber))
          INTO v_len
          FROM basetab_810 b
         WHERE b.upnumber like '4008%'
           AND rownum = 1;
     IF v_upnum LIKE '95%'
       THEN
        SELECT length(rtrim(upnumber))
          INTO v_len
          FROM basetab_810 b
         WHERE b.upnumber LIKE '95%'
           AND rownum = 1;
        dbms_output.put_line('v_count = ' || v_count);