Re: Environment Variables inside Oracle Procedures?

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 05 Sep 2007 20:24:15 -0500
Message-ID: <46df4ab7$0$17114$88260bb3@free.teranews.com>

> We need to change an one of the directories in an http_util call based
> on whether we are pointing to prod vs dev.

Why not query from V$INSTANCE? That will tell you the SID and the hostname. From that, you should be able to deduce whether you are on prod or dev.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Wed Sep 05 2007 - 20:24:15 CDT