SYS_CONTEXT ('USERENV', 'HOST') in a dbms_job

  • From: "Hitchman, Peter" <Peter.Hitchman@xxxxxxxxxxx>
  • To: "ORACLE-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 26 Nov 2004 10:24:55 -0000

Hi,
I have some code which calls SYS_CONTEXT ('USERENV', 'HOST'), that works
fine when it runs in a procedure and the procedure is invoked via sqlplus.
But when the same procedure is called via a database job it appears to be
returning nothing. Does anyone know about this?

Thanks

Pete

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________
--
//www.freelists.org/webpage/oracle-l

Other related posts: