SYS_CONTEXT
Hi there,
I tested SYS_CONTEXT('USERENV','HOST') function and received NULL.
SELECT SYS_CONTEXT('USERENV','HOST') FROM DUAL
from HTML DB.
I sow in documentation for iSQL*Plus restriction about 'HOST' parameter.
Every one sys function works in SE.
There is information about that in other forums, but not for XE.
I have two questions.
- If there are restrictions on SYS functions, are they same as iSQL*Plus.
- Which package to use instead.
I need to obtain OS user, workgroup, and computer name.
Thank you.
Message was edited by:
konstantin.gudjev