From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-0.5 required=5.0 tests=BAYES_00,INVALID_MSGID,
	PP_MIME_FAKE_ASCII_TEXT autolearn=no autolearn_force=no version=3.4.4
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 103376,944d2bfc44ba5a77
X-Google-Attributes: gid103376,public
From: "Pascal Obry" <p.obry@wanadoo.fr>
Subject: Re: Ada95 bindings to Oracle
Date: 2000/01/19
Message-ID: <863vtk$qr3$1@wanadoo.fr>#1/1
X-Deja-AN: 574615639
References: <861o0p$2u7$1@nnrp1.deja.com> <861rrv$d1$1@hobbes2.crc.com>
 <862jin$oho$1@nnrp1.deja.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
X-Complaints-To: abuse@wanadoo.fr
X-Trace: wanadoo.fr 948273908 27491 193.250.41.38 (19 Jan 2000 09:25:08 GMT)
Organization: home
NNTP-Posting-Date: 19 Jan 2000 09:25:08 GMT
Newsgroups: comp.lang.ada
Date: 2000-01-19T09:25:08+00:00
List-Id: <comp.lang.ada>

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"