Re: Problem calling a function from ODBC application

It's actually without time zone. However, it doesn't seem like ODBC allows me to specify that. When I bind the parameter, I can only say: SQL_TYPE_TIMESTAMP.

-----Original Message-----
From: Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
Sent: Friday, February 3, 2017 4:45 PM
To: Vilches, Alejandro <alejandro(dot)vilches(at)intel(dot)com>; Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Problem calling a function from ODBC application

Hi,

On 2017/02/04 9:31, Vilches, Alejandro wrote:
> Oh goodness, that's embarrassing :).
>
> Okay, so I've tried the following:
>
> - I fixed the small sample program and now that one executes successfully
>
> - I created another sample program that calls a stored function with the same number of parameters and types as the one in my real application and now that fails with the following error message (the same error message I originally reported):
> ERROR: function my_function3(bigint, bigint, integer, integer, timestamp with time zone, integer, integer, integer, integer, integer, integer, unknown, unknown) does not exist;

Is the type of parameter 'timestamp with time zone' right?

> Error while preparing parameters
>
> I've attached the new sample program. The stored function can be any dummy function.
>
> Thanks!
> Alejandro