IFS - Oracle Character Problem Solved

 Oracle database ve IFS üzerinde kendi geliştirdiğiniz uygulamalarda dil problemi yaşıyorsanız, kendi oluşturduğum aşağıdaki prosedürü programınızın başlangıcında kullanmanız yeterli olacaktır.

If you are experiencing language problems in the applications you have developed on Oracle database and IFS, it will be sufficient to use the procedure below that I have created at the beginning of your program.

CREATE OR REPLACE PROCEDURE H_Lang_Character_Solve AS

BEGIN

    EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE = ''TURKISH''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TERRITORY = ''TURKEY''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_CURRENCY = ''?''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_ISO_CURRENCY = ''TURKEY''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '',.''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_CALENDAR = ''GREGORIAN''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT = ''DD/MM/RRRR''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_LANGUAGE = ''TURKISH''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_SORT = ''TURKISH''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TIME_FORMAT = ''HH24:MI:SSXFF''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TIMESTAMP_FORMAT = ''DD/MM/RRRR HH24:MI:SSXFF''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TIME_TZ_FORMAT = ''HH24:MI:SSXFF TZR''';;

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = ''DD/MM/RRRR HH24:MI:SSXFF TZR''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DUAL_CURRENCY = ''TL''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_COMP = ''BINARY''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LENGTH_SEMANTICS = ''CHAR''';

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NCHAR_CONV_EXCP = ''FALSE''';

END;

--- Alternatif; 

BEGIN 

  IFSAPP.FND_SESSION_UTIL_API.Set_Fnd_User_('IFSAPP');  

  EXECUTE IMMEDIATE 'alter session set nls_language=turkish';

 END;