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=-1.3 required=5.0 tests=BAYES_00,INVALID_MSGID
	autolearn=no autolearn_force=no version=3.4.4
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 103376,908bd475d3545aad
X-Google-Attributes: gid103376,public
From: "Tony Matthews" <tony.matthews@SpamJam.gecm.com>
Subject: Re: PL/SQL -> Ada
Date: 2000/03/27
Message-ID: <38df972e$1@pull.gecm.com>#1/1
X-Deja-AN: 603021248
Content-Transfer-Encoding: 7bit
References: <38DD3CA8.BF122672@wa8tzg.org> <38DE46E8.756F5A66@quadruscorp.com>
 <38DE8D9B.83F8D13B@nord-com.net>
X-Priority: 3
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
X-Trace: 27 Mar 2000 18:15:26 GMT, 141.196.71.132
Organization: Alenia Marconi Systems
X-MSMail-Priority: Normal
MIME-Version: 1.0
Newsgroups: comp.lang.ada
Date: 2000-03-27T00:00:00+00:00
List-Id: <comp.lang.ada>

Andreas Schulz <accot.schulz@nord-com.net> wrote in message
news:38DE8D9B.83F8D13B@nord-com.net...

> "Marin D. Condic" wrote:
> > At one time in the not too distant past, I spent a great deal of time
> > programming in Ada, connecting to SQL for access to the Rdb database.
> > DEC had an SQL pre-processor for Ada that made this pretty painless. (As
> > you know, this is now owned by Oracle and is being migrated - if not
> > already - to match the Oracle product.)
>
> Emmm - what decade (or product?) are you talking about ?
> The Oracle Pro*Ada precompiler has been in use for years,
> until they decided to abondon it with Oracle 8, concentrating
> on Pro*C and Pro*COBOL (IMHO) due to lack of request.
>
> Andreas

Oracle haven't completely abandoned Ada. It's true that all ProAda
precompiler development has been stopped for some time now, but they have
replaced ProAda with SqlModule Ada. I'm not sure how many different
platforms are supported, but Windows NT and SCO UnixWare are certainly
amongst them.

It is a completely different beast to ProAda, though, in the way that it is
used. As far as I can determine, you write PL/SQL subprograms/packages to do
the jobs you want done and pass them through SqlModule, which spits out Ada
Specs for you to compile against (and presumably chunks of object code for
you to link against).

We've got masses of the stuff that we have to migrate, somehow!

Tony M.

--

       Any opinions expressed above are mine.
 To reply by E-Mail remove "SpamJam." from my address.
+===========================+=========================+
| Tony Matthews             |     Senior S/W Engineer |
|                           |  Alenia Marconi Systems |
| Tel: +44 (0)1633 835110   |             Ty-Coch Way |
|                           |                 Cwmbran |
| Fax: +44 (0)1633 835022   |                   Gwent |
|                           |                NP44 7XX |
| E-Mail:                   |                      UK |
|   tony.matthews@gecm.com  |                         |
+===========================+=========================+