SYS_CONTEXT not returning results
karambosMay 28 2013 — edited May 28 2013Hi - noobie question,sorry in advance.
I'm studying for the OCA and I've come across a function called SYS_CONTEXT
[http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions184.htm#SQLRF06117]
I'm trying to retrieve my own IP address by using SYS_CONTEXT('USERENV', 'IP_ADDRESS'). SQL*Plus is accepting it but returning nothing and I don't know why. I've tried a few arguments (e.g. SYS_CONTEXT('USERENV', 'AUTHENTICATION_DATA') but still nothing is returned. Always using USERENV as I believe this is the built-in namespace in Oracle.
any advice helpful at this point.
PS I'm connected to OracleXE as SYSTEM