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
X-Google-Thread: 103376,89e2ed92b27de792
X-Google-NewGroupId: yes
X-Google-Attributes: gida07f3367d7,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII
Path: 
 g2news2.google.com!news4.google.com!feeder.news-service.com!npeer.de.kpn-eurorings.net!npeer-ng0.de.kpn-eurorings.net!newsfeed.arcor.de!newsspool4.arcor-online.net!news.arcor.de.POSTED!not-for-mail
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Subject: Re: Problem in GNATColl when using prepared queries:
 GNATCOLL.SQL.POSTGRES.GNADE.POSTGRESQL_ERROR is raised
Newsgroups: comp.lang.ada
User-Agent: 40tude_Dialog/2.0.15.1
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Reply-To: mailbox@dmitry-kazakov.de
Organization: cbb software GmbH
References: <4d67ce9c$0$23765$14726298@news.sunsite.dk>
 <1on2yzc25jxpr.1offs3nb41fqk$.dlg@40tude.net>
 <4d67f3db$0$23762$14726298@news.sunsite.dk>
 <1dbprbhut7js1.jeytwwyjsya4$.dlg@40tude.net>
 <4d682437$0$23760$14726298@news.sunsite.dk>
 <1v42jcu30zmag$.1xz86498g3zsm.dlg@40tude.net>
 <4d6a6559$0$23761$14726298@news.sunsite.dk>
Date: Sun, 27 Feb 2011 16:36:49 +0100
Message-ID: <9p045csql006.z0zf57fkwrex.dlg@40tude.net>
NNTP-Posting-Date: 27 Feb 2011 16:36:47 CET
NNTP-Posting-Host: 1858579d.newsspool3.arcor-online.net
X-Trace: 
 DXC=lXoHh=1K<h`]l@YUW5NBknMcF=Q^Z^V3h4Fo<]lROoRa8kF<OcfhCOkY7BZ6_olbhc[6LHn;2LCVn[<mhadbfdUk4AI9H;MfH1nAW\DTg9XiWd
X-Complaints-To: usenet-abuse@arcor.de
Xref: g2news2.google.com comp.lang.ada:18598
Date: 2011-02-27T16:36:47+01:00
List-Id: <comp.lang.ada>

On Sun, 27 Feb 2011 15:53:13 +0100, Thomas L�cke wrote:

> I've done some further digging, and it appears that GNATColl thinks the
> result is binary data when the query is prepared. When the same query is
> executed without preparing it, the data is returned just fine as Integer
> and String respectively.

In that case it seems that the results of the prepared statement must be
bound. Does GNATColl support them? Technically bound results are fetched
automatically when the cursor moves through the result set.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de