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: Get database name in OCI or Transact-SQL

Re: Get database name in OCI or Transact-SQL

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 01 Oct 2002 01:16:10 GMT
Message-ID: <uH6m9.469950$kp.1327430@rwcrnsc52.ops.asp.att.net>


I don't know how using Transact SQL would work with an Oracle database. Transact-sql is a MS SQLServer thing.
You could get the information from a v$table in the database. Look in the Oracle Reference guide.
Jim
"Michael Chen" <michaelc7_at_earthlink.net> wrote in message news:Q61m9.1053$OB5.100694_at_newsread2.prod.itd.earthlink.net...
> Hello,
>
> In Oracle 8i, function OCIDescribeAny can return OCI_PTYPE_DATABASE type
> information such as OCI_ATTR_CURSOR_COMMIT_BEHAVIOR and
> OCI_ATTR_LIST_SCHEMAS. To get the handle from OCIDescribeAny for a
> database, you need to pass the database name:
>
>
>

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89857/oc
> i15r32.htm
> also
>
>

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89857/oc
> i06des.htm#444119
>
> The problem is my OCI connection may not have prior knowledge of the
> database name. What is passed to function OCIServerAttach may be just the
> TNS alias name defined in tnsnames.ora. Is there any way in OCI or
> Transact-SQL for me to get the database name after the connection is
> established?
>
> Thank for your help.
>
> --Michael
>
>
Received on Mon Sep 30 2002 - 20:16:10 CDT

Original text of this message

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