Re: SYS_CONTEXT ('USERENV', 'HOST') in a dbms_job
- From: Edgar Chupit <chupit@xxxxxxxxx>
- To: peter.hitchman@xxxxxxxxxxx
- Date: Fri, 26 Nov 2004 14:35:37 +0200
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@xxxxxxxxxxx> 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
> ______________________________________________________________________
> --
> //www.freelists.org/webpage/oracle-l
>
--
Edgar
--
//www.freelists.org/webpage/oracle-l
Other related posts:
