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: 
 g2news1.google.com!news2.google.com!goblin1!goblin.stu.neva.ru!news.musoftware.de!wum.musoftware.de!news.weisnix.org!newsfeed.ision.net!newsfeed2.easynews.net!ision!newsfeed.arcor.de!newsspool2.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>
Date: Fri, 25 Feb 2011 17:05:50 +0100
Message-ID: <1on2yzc25jxpr.1offs3nb41fqk$.dlg@40tude.net>
NNTP-Posting-Date: 25 Feb 2011 17:05:51 CET
NNTP-Posting-Host: df63db29.newsspool2.arcor-online.net
X-Trace: 
 DXC=U?VIR4FDiRd^Y=RbYBPl4`A9EHlD;3Ycb4Fo<]lROoRa8kF<OcfhCOkcmYCB@kH:^e[6LHn;2LCVn[<mhadbfdUkUB9=4ged<[f[AMSUl\Za>i
X-Complaints-To: usenet-abuse@arcor.de
Xref: g2news1.google.com comp.lang.ada:17599
Date: 2011-02-25T17:05:51+01:00
List-Id: <comp.lang.ada>

On Fri, 25 Feb 2011 16:45:32 +0100, Thomas L�cke wrote:

> If I do this:
[...]

I don't understand your code, in particular where the statement prepared is
actually executed? Where the cursor gets closed? DBMS does not appreciate
cursors left unclosed. Does GNATColl maintain cursor states internally? Why
fetch is not called within a loop? You prepare the statement, but do not
bind parameters, Ludovic mentioned this. I can only stress that you will
never get it working with literal values. I've been there. It isn't worth
to try.

... and why don't you use GNADE ODBC?

[ At least ODBC has tracing mode, which sometimes with some drivers indeed
traces. So that you could see the actual statement. ]

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