Re: Ada95 bindings to Oracle

["Pascal Obry" <p.obry@wanadoo.fr>]

[-- 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"