Interface GNAT with Oracle

Interface GNAT with Oracle

[Jeff Etrick]

 I am currently converting one of our applications to Ada9x using GNAT. 
Has anyone tried interfacing GNAT with any databases (eg. Oracle)


Thanks,

Jeff

Re: Interface GNAT with Oracle

[Robert Dewar]

I don't know anything specific about GNAT and ORACLE working together, but
an important thing to remember is that the GNAT calling sequence is exactly
the C calling sequence, and the GNAT datatypes correspond to the C
datatypes (e.g. int = integer, char = character). Access types and
address values in GNAT look like C pointers EXCEPT for access types for
unconstrained arrays, which are quite different, so avoid their use in
low level interface code.

Re: Interface GNAT with Oracle

[WLawton]

In article <389@sphinx.CSS.GOV>, jeffe@sphinx.CSS.GOV (Jeff Etrick)
writes:

>
> I am currently converting one of our applications to Ada9x using GNAT. 
>Has anyone tried interfacing GNAT with any databases (eg. Oracle)
>
I have spent the last two weeks attempting to discuss Ada-9x and GNAT with
the good (?) people at Oracle.  Out of three technical reps, four
salespeople, and two semi-managers, I found ONE who knew what Ada was. 
That individual stated that Oracle was committed to compliance with the
latest standards.  He promptly faxed me three pages from the Pro*Ada
reference manuals identifying the various levels/standards of SQL that
Oracle supported.  

Even this former Marine knows when to quit hitting his head against the
wall.

Does anyone else know of a DBMS that will operate with GNAT?  Preferably
with an existing Ada interface?
And SQL support, as long as I am dreaming?

Vendors feel free to reply.  Summary will be posted if I recieve more than
two responses.

Wayne R. Lawton

Re: Interface GNAT with Oracle

[Charles W. Kann]

WLawton (wlawton@aol.com) wrote:
: In article <389@sphinx.CSS.GOV>, jeffe@sphinx.CSS.GOV (Jeff Etrick)
: writes:

: >
: > I am currently converting one of our applications to Ada9x using GNAT. 
: >Has anyone tried interfacing GNAT with any databases (eg. Oracle)
: >
: I have spent the last two weeks attempting to discuss Ada-9x and GNAT with
: the good (?) people at Oracle.  Out of three technical reps, four
: salespeople, and two semi-managers, I found ONE who knew what Ada was. 
: That individual stated that Oracle was committed to compliance with the
: latest standards.  He promptly faxed me three pages from the Pro*Ada
: reference manuals identifying the various levels/standards of SQL that
: Oracle supported.  

: Even this former Marine knows when to quit hitting his head against the
: wall.

: Does anyone else know of a DBMS that will operate with GNAT?  Preferably
: with an existing Ada interface?
: And SQL support, as long as I am dreaming?

: Vendors feel free to reply.  Summary will be posted if I recieve more than
: two responses.

: Wayne R. Lawton

Any database which has a C interface should run with GNAT using the PRAGMA
IMPORT.  I know  you could do this with SYBASE, but it would take some
work.


--
chuck kann
ckann@seas.gwu.edu

Re: Interface Ada with Oracle

[Hoaglund]

In article <389mi6$ql0@newsbf01.news.aol.com>, wlawton@aol.com (WLawton)
writes:
>I have spent the last two weeks attempting to discuss Ada-9x and GNAT
with
>the good (?) people at Oracle.  Out of three technical reps, four
>salespeople, and two semi-managers, I found ONE who knew what Ada was.

This whole thread is filling me with dread. I am on a new project that is
attempting a blind leap forward into using a commercial database (almost
certainly Oracle) instead of using our old mainframe based homegrown
FORTRAN database.  We have 1 Oracle expert who has never used Ada and a
bunch of former FORTRAN- now- Ada programmers who have never used a RDBMS.
 Now I hear that the tool we need to use to interface is going to come
from a place without decent Ada credentials???  Oh-oh!!  

Is there anybody out there that has experience using Ada as the outside
shell to connect to a RDBMS inside?  The Oracle sales people talk a good
talk about Ada support, but do they really?  The initial limited
development system we have is Oracle, but the final decision is not in on
what will be delivered at the end.

Cathy Hoaglund  (not speaking for my employer)
hoaglund@aol.com