Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Basic OCI Information needed
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
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
![]() |
![]() |