I have a requirement to provide CSV separator based on user preference when he downloads an interactive report.
I tried to change NLS setting dynamically using a page process on page load but it didn't work.
used below code but no success-
IF :G_NS_CSV_SEPARATOR_USER = ';' THEN
EXECUTE IMMEDIATE('ALTER SESSION SET NLS_LANGUAGE = GERMAN');
EXECUTE IMMEDIATE('ALTER SESSION SET NLS_TERRITORY = GERMANY');
EXECUTE IMMEDIATE('ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '',;''');
ELSE -- Separator is ,
EXECUTE IMMEDIATE('ALTER SESSION SET NLS_LANGUAGE = AMERICAN');
EXECUTE IMMEDIATE('ALTER SESSION SET NLS_TERRITORY = AMERICA');
EXECUTE IMMEDIATE('ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ''.,''');
END IF;
Any suggestions?
Regards,
sarvesh