That's because job is executed in the background process on the server
and this field is not populated for background processes. This is the
same value as MACHINE in the v$session view. That's because
background processes doe not connect to DB via LISTENER, but are
directly attached to SGA.
On Fri, 26 Nov 2004 10:24:55 -0000, Hitchman, Peter
<peter.hitchman_at_thomson.com> wrote:
> 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
> ______________________________________________________________________
> --
> http://www.freelists.org/webpage/oracle-l
>
--
Edgar
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 26 2004 - 06:31:14 CST
