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

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Fri, 26 Nov 2004 15:41:03 +0000 (GMT)
Message-ID: <20041126154103.71300.qmail@web86904.mail.ukl.yahoo.com>

I'm sure you already know this, but you could always drag it out of v$instance

hth
connor

• "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
  >
  

  ---

Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

---

                

---

Win a castle for NYE with your mates and Yahoo! Messenger http://uk.messenger.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 26 2004 - 09:37:17 CST