Ada95 bindings to Oracle

Ada95 bindings to Oracle

[Oliver Kellogg]

Hi,

Has anyone done, or is anyone currently doing,
Ada95 bindings to Oracle (preferably version 7) ?

Thanks,

Oliver M. Kellogg
-- okellogg@freenet.de


Sent via Deja.com http://www.deja.com/
Before you buy.

Re: Ada95 bindings to Oracle

[David C. Hoos, Sr.]

Oliver Kellogg <okellogg@my-deja.com> wrote in message
news:861o0p$2u7$1@nnrp1.deja.com...
> Hi,
>
> Has anyone done, or is anyone currently doing,
> Ada95 bindings to Oracle (preferably version 7) ?
>
Are you referring to the OCI, or SQL*Module, or what?

Re: Ada95 bindings to Oracle

[Oliver Kellogg]

In article <861rrv$d1$1@hobbes2.crc.com>,
  "David C. Hoos, Sr." <david.c.hoos.sr@ada95.com> wrote:
> Are you referring to the OCI, or SQL*Module, or what?

The Pro*Ada predefined packages are Ada83 (is this called
"OCI" ?)

Package ORACLE is huge and uses a lot of nested packages,
this could profit from child packages.
The interfacing with C is the usual mess that it was
in Ada83, this could profit from pragma Convention (C),
Interfaces.C, the unsigned types in package Interfaces etc.
I've already substituted the non-portable semaphore
implementation with a protected type. <wax mode off>



Sent via Deja.com http://www.deja.com/
Before you buy.

Re: Ada95 bindings to Oracle

[Pascal Obry]

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #1: Type: text/plain, Size: 1268 bytes --]

Oliver Kellogg a �crit dans le message <862jin$oho$1@nnrp1.deja.com>...
>In article <861rrv$d1$1@hobbes2.crc.com>,
>  "David C. Hoos, Sr." <david.c.hoos.sr@ada95.com> wrote:
>> Are you referring to the OCI, or SQL*Module, or what?
>
>The Pro*Ada predefined packages are Ada83 (is this called
>"OCI" ?)
>


No, OCI means Oracle Call Interface (if my memory is right) and is
a very low level interface to the Oracle engine. This has been said
to not be supported anymore by Oracle since 8 years or so... but
it is actually there in the latest version.

One solution (that I have used in a project) is to use PRO*C which
is well supported and defined the Ada interface to each PRO*C
support calls in Ada. Either by hand or by a small awk (or whatever)
scripts. You should consider to generate the information about tables,
fields... from the database as an Ada package to be used by the above
interface.

Pascal.

--|------------------------------------------------------
--| Pascal Obry                           Team-Ada Member
--| 45, rue Gabriel Peri - 78114 Magny Les Hameaux FRANCE
--|------------------------------------------------------
--| http://ourworld.compuserve.com/homepages/pascal_obry
--|
--| "The best way to travel is by means of imagination"