Re: accessing SQLPlus variables.................

rs_arwar_at_hotmail.com (Rauf Sarwar) writes:
> Module is always constant as "SQL*Plus" for sqlplus.exe or
> sqlplusw.exe no matter what the exe name is changed to..

For general background info: the "module" column for non privileged SQL*Plus sessions contains the value set by APPINFO. (See SET APPINFO in the SQL*Plus UG&R manual.)

Any scripts run including glogin.sql and login.sql will cause the value to contain the script name. The user can explicitly change the value too. For the iSQL*Plus web interface the default value (when APPINFO is ON) is "iSQL*Plus"

Chris

-- 
Christopher Jones, Oracle Corporation, Australia.