Skip site navigation (1) Skip section navigation (2)

Output parameters

From: Bart Samwel <bart(at)samwel(dot)tk>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Output parameters
Date: 2006-05-17 08:46:07
Message-ID: 446AE2CF.5070607@samwel.tk (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi there,

I've got a situation with the experimental enhanced branch driver 
(version 7.03.02.66), PostgreSQL 8.1 backend. I'm executing a query such as:

SELECT myproc(?,?,?,?,?,?,?)

where a number of the parameters are output parameters. I've bound 
buffers to the output parameters, but when I read the values, they 
contain garbage (uninitialized data, to be precise -- 0xcdcdcdcd). The 
first result row then contains the output parameter values. I'd expect 
the result row, as this is how PostgreSQL implements output parameters, 
but does anybody have any clue why the bound buffers for the output 
parameters aren't filled?

Thanks in advance for your help!

Cheers,
Bart


Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2006-05-17 12:46:00
Subject: Re: Output parameters
Previous:From: Jonathan BlitzDate: 2006-05-16 16:41:39
Subject: SQLCODE when using psqlODBC with libODBC++

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group