Oracle EBS：Oracle 字符集到Windows字符集的转换 carlo

BEGIN
      SELECT v.tag
        INTO l_client_charset
        FROM fnd_lookup_values_vl v
       WHERE v.lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
         AND v.lookup_code =
             fnd_profile.value('FND_NATIVE_CLIENT_ENCODING')
         AND v.enabled_flag = 'Y'
         AND trunc(SYSDATE) BETWEEN
             nvl(v.start_date_active, trunc(SYSDATE - 1)) AND
             nvl(v.end_date_active, trunc(SYSDATE + 1));
    EXCEPTION
      WHEN no_data_found THEN
        l_client_charset := 'UTF-8';
    END;

　　fnd_profile.value('FND_NATIVE_CLIENT_ENCODING') 为 EBS 系统字符集

　　v.tag 为 相应的 Windows 字符集