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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Basic OCI Information needed

Re: Basic OCI Information needed

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 13 Dec 1998 15:00:12 GMT
Message-ID: <367ed4e2.10664674@192.86.155.100>


A copy of this was sent to "Paul Sanders" <paul_at_jsl.softnet.co.uk> (if that email address didn't require changing) On Sun, 13 Dec 1998 14:27:52 -0000, you wrote:

>Hi
>
>I am completly new to the world of OCI and have a couple of questions.
>
>1 Can windows tools be written using the OCI, or is it for Pro*C stuff only

oci and pro*c may both be used on windows.

>2 If Windows, are there any sites that I can get some examples from

well, any OCI example will work. there are examples in \orant\ociXX\samples. OCI for windows is identical to OCI for unix/mainframes, etc.

>3 I've seen an example of connecting to the database that does'nt seem to
>use
> a DSN - How would I specify one?

same way you connect with sqlplus. You give a username, password and if you want -- a tns connect string (eg: scott/tiger_at_somedatabase)

>4 Are there any stats on the performance differences between OCI and ODBC
>

odbc is a layer on top of OCI. odbc can only hope to be as fast as OCI (probably not since its a layer). If you learn how to maximize oci, oci will certainly beat odbc. Of course, just like you can write bad odbc apps -- you can write bad oci apps that do not perform well...

>
>
>Any comments would be gratefully appreciated
>
>Paul
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Dec 13 1998 - 09:00:12 CST

Original text of this message

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