Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to determine db name for a connection

Re: How to determine db name for a connection

From: Scott D. DeWitt <dewittsc_at_us.ibm.com>
Date: Wed, 08 Dec 1999 13:41:40 -0500
Message-ID: <384EA664.6DABA2EC@us.ibm.com>


Thanks, I'll give that a try.

Scott

no spam wrote:

> Select name
> from v$database
>
> can also check the other V$ views for additional information
>
> Scott D. DeWitt wrote in message <384D2422.1D266F3B_at_us.ibm.com>...
>
> >I need a way to determine the database name for a given connection. We
> >have a situation in which we call a user DLL that could make a database
> >connection to an Oracle database. However, in the calling application,
> >we do not know the name of the database this DLL will connect to since
> >it is specified by the user at runtime in the DLL. When we return to
> >the calling DLL, we want to re-use the connection if it was
> >established. It is easy enough to determine whether or not a connection
> >exists by doing some dummy SQL and seeing if I get a -1012. However, if
> >a connection does exist, I need to know the name of the database for
> >this connection.
> >
> >Is there any way to obtain connection information about the current
> >database connection if one exists?
> >
> >Your help would be appreciated.
> >Thanks in advance,
> >Scott DeWitt
Received on Wed Dec 08 1999 - 12:41:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US