1 Reply Latest reply: Nov 5, 2013 2:48 PM by f65bde79-3f78-411a-ac88-8817db48d7e1 RSS

    Reports in Character Mode - Special Characters

    f65bde79-3f78-411a-ac88-8817db48d7e1

      Hi!, I have a problem, i'm using Reports in character mode and it creates a PostScript in UNIX, The reports creates a barcode with a function, but this function has Special Characters and the system automatically replace it with "?" or "!".

      The function is:

       

      FUNCTION F_GETBARCODE(pv_digitos_afip  IN VARCHAR2) RETURN VARCHAR2 IS
        --
        ln_len NUMBER;
        lv_pair VARCHAR2(50);
        lv_codebar VARCHAR2(50) := '{';
        --
        TYPE ARRAY_T IS VARRAY(101) OF VARCHAR2(10);
        ARRAY ARRAY_T := ARRAY_T('!','"','#','$','%','&','''','(',')','*','+',',','-','.','/','0','1','2','3','4','5','6','7','8','9',':',';','<','=','>','?','@','A','B','C','D','E','F',
                                                      'G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','[','\',']','^','_','`','a','b','c','d','e','f','g','h','i','j','k','l',
                                                      'm','n','o','p','q','r','s','t','u','v','w','x','y','z','¡','¢','£','¤','¥','¦','§','¨','©','ª');
      BEGIN
        --
        SELECT LENGTH(pv_digitos_afip)/2
            INTO ln_len
           FROM DUAL;
        --
        FOR i IN 1..ln_len LOOP
          --
          SELECT SUBSTR(pv_digitos_afip,i+i-1,2)
              INTO lv_pair
              FROM DUAL;
          --
          lv_codebar := lv_codebar||ARRAY(TO_NUMBER(lv_pair+1));
          --
        END LOOP;
        --
        lv_codebar := lv_codebar||'}';  
        --
        RETURN lv_codebar;
      END;
      

       

      If the number is , 909192 the function whould returns {¡¢£} , but returns {!??}

       

      The problem is with this characters '¡','¢','£','¤','¥','¦','§','¨','©','ª' , I cannot create the barcode without chars. ¿Some ideas or solution?

       

       


      Thanks Regards.