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.4 required=5.0 tests=BAYES_00,FORGED_MUA_MOZILLA autolearn=no autolearn_force=no version=3.4.4 X-Google-Thread: 103376,2b652854118b67f9,start X-Google-NewGroupId: yes X-Google-Attributes: gida07f3367d7,domainid0,public,usenet X-Google-Language: ENGLISH,ASCII Received: by 10.42.141.194 with SMTP id p2mr14276695icu.8.1320348891565; Thu, 03 Nov 2011 12:34:51 -0700 (PDT) Path: p6ni67463pbn.0!nntp.google.com!news2.google.com!news.glorb.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail Date: Thu, 03 Nov 2011 20:34:50 +0100 From: =?ISO-8859-1?Q?Thomas_L=F8cke?= User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.21) Gecko/20110905 Thunderbird/3.1.13 MIME-Version: 1.0 Newsgroups: comp.lang.ada Subject: GNATColl and support for PostgreSQL stored procedures and non-public schemas Message-ID: <4eb2ecda$0$290$14726298@news.sunsite.dk> Organization: SunSITE.dk - Supporting Open source NNTP-Posting-Host: 77.234.175.34 X-Trace: news.sunsite.dk DXC=gR;RL:=OPE\5LoVIWDNeH\YSB=nbEKnk[dCdCeJ7VQc\3ZOKe3?:>XQcAE?;m5ccYSXohdXkZjmRV;oYRhm0RA^X X-Complaints-To: staff@sunsite.dk Xref: news2.google.com comp.lang.ada:14296 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Date: 2011-11-03T20:34:50+01:00 List-Id: Hey, Are there any plans for adding support for non-public schemas to the gnatcoll_db2ada tool? Right now we have to resort to embedded SQL instead of using the excellent GNATCOLL.SQL Ada style SQL interface. Would it perhaps be possible to use the textual description method found here: http://goo.gl/8ORh4 And if yes, then how? And how about stored procedures? We use those A LOT in our application but we haven't been able to figure out how to make use of them without having to go back to plain old embedded SQL, which of course is sub- optimal. Any and all hints are more than welcome! :o) -- Thomas L�cke Email: tl at ada-dk.org Web: http//:ada-dk.org http://identi.ca/thomaslocke