Re: How to get the servername?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 26 Nov 2002 00:43:07 -0800
Message-ID: <a20d28ee.0211260043.4a29708_at_posting.google.com>


duanez_at_attbi.com (duanem) wrote in message news:<356a5aee.0211251139.1ddf5c3a_at_posting.google.com>...
> Please help! I know how to get the servername from using the Owa_util
> package with get_cgi_env. However, when I try to run a sqlplus script
> using that I get an error.
>
> Is there a way to get the server name on which a sqlplus script or
> plsql procedure is running? In MS Sql server, I can do something like
> "Select _at__at_servername" from isql and get the servername that way. But I
> am not finding a similar function or env variable for the sqlplus
> environment.

The answer is version dependent. No one in this group is clairvoyant. If you want help please always include platform and version.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue Nov 26 2002 - 09:43:07 CET

Original text of this message