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,ea931d5a914b534f
X-Google-Attributes: gid103376,public
From: John J Cupak Jr <John_J_Cupak@res.raytheon.com>
Subject: Re: Ada and SQL commands?
Date: 1999/04/06
Message-ID: <370A788C.9F92B599@res.raytheon.com>#1/1
X-Deja-AN: 463389441
References: <7ebn1k$mn$1@news.iinet.net.au>
To: Cameron Hodge <vampyre@ozemail.com.au>
Content-Type: multipart/mixed; boundary="------------001C8FD034EB431D3AA47AD6"
X-Complaints-To: usenet@swl.msd.ray.com
X-Trace: swlmail.msd.ray.com 923433106 7973 138.127.111.45 (6 Apr 1999
 21:11:46 GMT)
Organization: Raytheon Systems Company
Mime-Version: 1.0
NNTP-Posting-Date: 6 Apr 1999 21:11:46 GMT
Newsgroups: comp.lang.ada
Date: 1999-04-06T21:11:46+00:00
List-Id: <comp.lang.ada>

This is a multi-part message in MIME format.
--------------001C8FD034EB431D3AA47AD6
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Well, Cameron and Robert,

I just checked my "SQL Instant Reference" manual (and recalling my RDB info),
here's what I came up with (it's been a while since I've done this, tho... so
don't blame me if I'm off a bit.):

1. There should be a SQL_STANDARD Ada package that you can call, and use the
routines embedded therein to interface with your favorite DB.
2. Use the SQL MODULE language to define SQL "procedures" (modules)
3. Write Ada(95, I hope) procedures to interface with the SQL module
procedures.

Of course, you gotta know SQL AND Ada(95) to make this all work right.

btw, Ada95 is not required.. just plain 'ol Ada (83) will do the trick, too!

Hope this helps,

John


Cameron Hodge wrote:

> Hey guys and gals. Just wondering is anyone aware of a library or package
> that handles SQL commands within ADA? I want to access data from an Oracle
> database from with in a program I am writing?
>
> vampyre@ozemail.com.au



--------------001C8FD034EB431D3AA47AD6
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for John J Cupak Jr
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             John J Cupak Jr
n:              Cupak Jr;John J
org:            Raytheon Systems Company
adr:            50 Apple Hill Road;;T3MN35;Tewksbury;MA;01876;USA
email;internet: John_J_Cupak@res.raytheon.com
title:          Software Engineering Instructor
tel;work:       978.858.1222
tel;fax:        978.858.4336
x-mozilla-cpt:  ;0
x-mozilla-html: TRUE
version:        2.1
end:            vcard


--------------001C8FD034EB431D3AA47AD6--