Re: Oracle 7 access from Linux

From: Dee Jay Randall <randal_at_mercury.cs.uregina.ca>
Date: 1997/07/26
Message-ID: <randal.869950275_at_mercury>#1/1


> Does anyone know if its possible to access an Oracle 7 database from
> Linux? Where can I find some information on this?
>
> http://cscsun1.larc.nasa.gov/~beowulf/db/ says that I need Oracle
> PRO*C and/or the Oracle Call Interface. Can someone explain to me
> what these are exactly and where I might get them?
>
> Thanks for any help,
> Lyle
> lhomer_at_xmission.com

  I've never tried to access Oracle 7 from Linux, but I've used PRO*C in SunOS, and the Oracle Call Interface in Visual C++ 5 (WinNT).

  Oracle PRO*C is an embedded sql precompiler for C. It lets you put sql statements in your C code and then the precompiler replaces them with calls to Oracle libraries. One uses it for simple static queries and simple database schema manipulation.

  To use Oracle PRO*C in Linux, you would need the precompiler compiled to run on Linux.

  The Oracle Call Interface (oci) gives you direct access to the Oracle Library functions. It is significantly more powerful than Oracle PRO*C and can be used for dynamic queries where almost nothing is known about the database until run time.

  To use the oci in Linux, you would need at least the library and some header files, maybe more, I'm not sure. You'd need at least liboci.* and ociapr.h, ocidfn.h, etc.

  Good luck, post your findings, I would be interested in finding out how this works.

  Later,

--
  Dee Jay Randall        _-~-_-~-_-~-_-~-_-~-_-~-_-~-_-~-_-~-_-~-_-~-_-~-_
  randal_at_cs.uregina.ca   |                                               |
                        { }      God is dead.      Nietsche is dead.    { }
    _-__-_  ouch,       { }        -Nietsche                 -God       { }
   >      <  that hurt   |                                               |
__)  chomp (___________  ~-_-~-_-~-_-~-_-~-_-~-_-~-_-~-_-~-_-~-_-~-_-~-_-~
Received on Sat Jul 26 1997 - 00:00:00 CEST

Original text of this message