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.3 required=5.0 tests=BAYES_00,
	REPLYTO_WITHOUT_TO_CC autolearn=no autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From: "G.B." <bauhaus@futureapps.invalid>
Newsgroups: comp.lang.ada
Subject: Re: Ada package registry?
Date: Fri, 5 Feb 2016 18:58:49 +0100
Organization: A noiseless patient Spider
Message-ID: <n92nnd$525$1@dont-email.me>
References: <02241ec4-0f95-4f63-9abc-092f167eb59e@googlegroups.com>
 <56af17b7$0$301$14726298@news.sunsite.dk> <n8n8ib$sqr$1@dont-email.me>
 <56b06eb8$0$301$14726298@news.sunsite.dk> <n8rcp6$f93$1@loke.gir.dk>
 <1454483747.2785.135.camel@obry.net> <n8ttvb$se2$1@loke.gir.dk>
 <n8vvfk$ml3$1@dont-email.me> <n90022$tgm$1@gioia.aioe.org>
 <n901l6$b7$1@dont-email.me> <n90fcu$rnk$1@loke.gir.dk>
 <n925rt$th2$1@dont-email.me> <n9280s$9es$1@gioia.aioe.org>
 <n92gda$725$1@dont-email.me> <n92jjv$uqo$1@gioia.aioe.org>
Reply-To: nonlegitur@futureapps.de
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 5 Feb 2016 17:55:57 -0000 (UTC)
Injection-Info: mx02.eternal-september.org;
 posting-host="b96887e80893c84a90c3007226ca0d1c";
	logging-data="5189"; mail-complaints-to="abuse@eternal-september.org";
	posting-account="U2FsdGVkX19pUz1BmwqhSSw63t2DVPpYUhhth6837w4="
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0)
 Gecko/20100101 Thunderbird/38.5.1
In-Reply-To: <n92jjv$uqo$1@gioia.aioe.org>
Cancel-Lock: sha1:NWFRjpa3C8GApHenT781a0icQto=
Xref: news.eternal-september.org comp.lang.ada:29363
Date: 2016-02-05T18:58:49+01:00
List-Id: <comp.lang.ada>

On 05.02.16 17:45, Dmitry A. Kazakov wrote:
> On 2016-02-05 16:53, G.B. wrote:
>
>> I mean "SQL-invoked routines", just the technical term of SQL.
>> ODBC is not necessarily involved, here. An Ada subprogram is being
>> called by the MS part of the DBMS, logically from within some
>> SQL statementent. As is done with stored procedures written in
>> SQL. E.g., when evaluating an expression, the DBMS passes database
>> values to an Ada function; when CALL-ing an Ada procedure, it
>> might expect the procedure to place a result into some IN OUT
>> parameter, or it might call the Ada procedure just for its effect.
>
> This is not how DB clients work.

It is how SQL-invoked routines are being done, by definition.
They are just written in languages other than Ada.

> SQL types have parameters and depend on the RDBMS. This is not working
> either.

We'd be talking about C types and UTFs, to cover the vast majority
of types used in all typical databases. That's a realistic
assumption.  ISO/IEC 8652 addresses these.

If needed, Interfaces.C provides a lot more already,
by defining how Ada implementations handle C structs,
such as geo points, and maybe enums.

How would this be "not working"?