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

最新推荐文章于 2021-10-20 17:54:44 发布

cheya4957

最新推荐文章于 2021-10-20 17:54:44 发布

阅读量105

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/u/1985061/blog/422576

版权

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;