RE: How to read client characterset in logon trigger?

SELECT SUBSTR(sql_text, 1, 2000) FROM sys.V_$OPEN_CURSOR WHERE UPPER (sql_text) LIKE 'ALTER SESSION%' with appropriate sid. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any

RE: How to read client characterset in logon trigger?

I suppose that would work if an alter session is used but what if the client is simply set up to use a different character set, for example if NLS_LANG is set to something other than the database character set. export NLS_LANG=Blah sqlplus foo/bar Now what character set is being used? I

RE: How to read client characterset in logon trigger?

I have seen forms do this all the time, i.e. without actually issuing the 'alter session ...' command, you can see they being done. I think it must be something to do with sqlnet. Have you tried it yet? Raj __ Rajendra Jamadagni

RE: How to read client characterset in logon trigger?

select sys_context('USERENV','LANGUAGE') FROM DUAL ??? -Original Message- Sent: Wednesday, July 24, 2002 11:05 AM To: Multiple recipients of list ORACLE-L Help me out here, is there a procedure or statement I can use to record client character set settings in a logon trigger? --