PDA

View Full Version : Calling Stored Procedure using ODBC



luiz.carlos.do.lago
20th November 2010, 23:35
It's my first time here on the List, I'm starting to tweak the QT already working with C++ for some time and now I am researching this framework.
I'm having problems accessing stored procedures in postgresql database using the ODBC driver.

Could anyone help me? here's the definition of the stored procedure for test

CREATE OR REPLACE FUNCTION "public". "test_01 (
"Param_01" numeric,
out param_02 "numeric,
out param_03 "numeric
)
RETURNS record AS
$ Body $
DECLARE

BEGIN
param_02: = param_01 * 2;
param_03: = param_02 * 2;
END;
$ Body $
LANGUAGE 'plpgsql'

Best Regards,

Luiz Lago