Message-ID: <4535D278.5030009@tellus.hr>
Date: Wed, 18 Oct 2006 09:06:32 +0200
From: Marko Bozikovic <marko.bozikovic@tellus.hr>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Postgres OLE DB provider - query parameters
Content-Type: text/plain;
	charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi all,

I'm new to PostgreSQL OLE DB (and PostgreSQL in general :) and I have a
problem with using OLE DB in my C++ code...

I'm porting some code from MS SQL to PostgreSQL... Here's an example of M=
S SQL
query class (insert_department procedure has two parameters: input string=
 name
and output int4 id):

[
db_command(L"EXECUTE insert_department ?, ? OUTPUT")
]
class QInsertDepartment
{
public:
    [ db_param(1, DBPARAMIO_INPUT) ] CComBSTR m_strName;
    [ db_param(2, DBPARAMIO_OUTPUT, status=3Dm_dwIDStatus) ] LONG m_lID;

    DBSTATUS m_dwIDStatus;
};

I know how to execute a PostgreSQL stored procedure, so I had to change t=
he
class for PostgreSQL a bit:

[
db_command(L"SELECT insert_department(?)")
]
class QInsertDepartment
{
public:
    [ db_param(1, DBPARAMIO_INPUT) ]      CComBSTR m_strName;
    [ db_column(1, status=3Dm_dwIDStatus) ] LONG     m_lID;

    DBSTATUS m_dwIDStatus;
};

Calling code looks something like this:

QInsertDepartment insertDepartment;

m_session.StartTransaction();

insertDepartment.m_strName =3D strName.c_str();

HRESULT hr =3D insertDepartment.Open(m_session);
if (FAILED(hr))
{
...
}
...

insertDepartment.Open() returns DB_E_PARAMNOTOPTIONAL. Here's the relevan=
t
part of the log file (execution of Open):

IDBCreateCommandImpl::CreateCommand
IObjectWithSiteImpl::SetSite
CPgCommand::SetCommandText "SELECT insert_department(?)"
ICommandTextImpl::SetCommandText
CPgCommand::SetParameterInfo
CErrorLookupService::ClearErrorIAccessorImpl::CreateAccessor
CPgCommand::Execute
CErrorLookupService::ClearErrorCPgCommand::FillParams
CErrorLookupService::ClearErrorICommandTextImpl::GetCommandText
IObjectWithSiteImpl::GetSite
IAccessorImpl::GetBindingsCPgCommand::Execute error: FillinValues failed
CErrorLookupService::ReportCustomError HRES 80040e10:
FillinValues failed


My guess is that there is a problem with parsing input parameter(s), sinc=
e
executing procedures without IN parmeters (just OUT) works ok.

Can anyone help me?

Thank you,
--=20
Marko Bo=C5=BEikovi=C4=87
Tellus d.o.o.
Tel.  +385 1 3691 975
Fax   +385 1 3691 976
E-Mail:  marko.bozikovic@tellus.hr
Ogrizovi=C4=87eva 40a
10000 Zagreb
Hrvatska