From: | Valerio Ferrucci <valfer(at)flashnet(dot)it> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Calling a function via ODBC |
Date: | 2002-11-06 16:36:49 |
Message-ID: | F24270E7-F1A5-11D6-86F7-00039377EF16@flashnet.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
I have postgres installed on my Machine (MacOSX) and connect to it via
ODBC from my C app.
All works ok (select, insert, update and so on).
Now I made the following simple function:
CREATE OR REPLACE FUNCTION concat_text (TEXT, TEXT) RETURNS TEXT AS '
BEGIN
RETURN $1 || $2;
END;
' LANGUAGE 'plpgsql';
and called it succesfully doing:
SQLExecDirect(... ""select concat_text('val', 'erio')"" ...)
and fetching the result with SQLFetchScroll etc..., all works ok.
SO WHICH IS THE QUESTION?
THE QUESTION IS:
Is there a way to call my func using the ODBC syntax:
{? = CALL concat_text(?, ?)}
using SQLBindParameter to bind variable (input/output) to '?' and
getting return value directly in a bound var (without any Fetch) (see
http://www.ddart.net/mssql/sql70/odbcht10_1.htm )?
Does someone have an example in using SQLBindParameter to set parameter
IN and get return value OUT?
Thanks for help
==================================================================
Valerio Ferrucci Tabasoft Sas
ferrucci(at)tabasoft(dot)it http://www.tabasoft.it
From | Date | Subject | |
---|---|---|---|
Next Message | Jinqiang Han | 2002-11-07 01:35:34 | about the setup file |
Previous Message | Hiroshi Inoue | 2002-11-06 00:12:09 | Re: CTID: Anyway to lock it? |