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

From: Hitchman, Peter <Peter.Hitchman_at_thomson.com>
Date: Fri, 26 Nov 2004 16:10:49 -0000
Message-ID: <8D697B8FCEBB3744B3A1E4AE15E8331E4B8878@der-lon-msg-03.derwent.co.uk>

Yep, I reached that conclusion. It has been pointed out to me that this does not work because the job is being executed in a background process and this context is only set for client connections.

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

Received on Fri Nov 26 2004 - 10:06:41 CST