ODBC, ADO, Return Value from SP problem

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: ODBC, ADO, Return Value from SP problem
Date: 2004-05-31 13:09:55
Message-ID: Pine.LNX.4.44.0405311453120.23164-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

I need use ADODB client via ODBC. I can call stored proc
without problems. I am sure so proc is called (I am loging params)
but retern value is always null.

dim cn as new ADODB.Connection()
cn.Open("DSN=intra","nepi")
Dim cmd As New ADODB.Command
Set cmd.ActiveConnection = cn
cmd.CommandText = "testcallsp"
cmd.CommandType = adCmdStoredProc
cmd.Parameters.Referesh()
cmd.Parameters(1).Value = 22
cmd.Execute()
MsgBox cmd.Parameters(0).Value 'only null :-((

Stored Proc is simply

CREATE OR REPLACE FUNCTION testcallsp(integer) RETURNS integer AS '
BEGIN
RAISE LOG ''% '', $1;
RETURN coalesce($1,10) + 1;
END; ' LANGUAGE plpgsql;

What is wrong please?

Thank You very much
Pavel Stehule

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2004-05-31 13:13:36 Re: Dump 7.1.3->7.4.2
Previous Message Ben-Nes Michael 2004-05-31 10:49:51 pg_dump and errors