[Oledb-dev] Oledb parametrized query

[mcgr at poczta.onet.pl]

Hi,
I have problem with parametrized query. 
 
(Code in .net C#)
OleDbConnection lvConnection = new OleDbConnection();
lvConnection.ConnectionString = "Provider=PostgreSQL; Data Source=localhost; Location = KANCELARIA; User id = postgres; Password = postgres;";
lvConnection.Open();
OleDbCommand lvCommand = new OleDbCommand();
lvCommand.Connection = lvConnection;
lvCommand.CommandType = CommandType.Text;
lvCommand.CommandText = "SELECT * FROM MIASTA WHERE id = :pmId";
OleDbParameter lvParam = new OleDbParameter("pmId", DbType.Int32);
lvParam.Value = 1;
lvCommand.Parameters.Add(lvParam);
lvCommand.ExecuteReader();
 
I get the following error:
System.Data.OleDb.OleDbException: FillinValues failed
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.ExecuteReader() ...
 
And the second problem - calling stored procedure  once more ... 
I read your answer and the first I tested:

CommandType = CommandType.Text;
CommandText = "SELECT * FROM test()";

It's OK, there is no error.

but when I tested 

CommandType = CommandType.StoredProcedure;
CommandText = "test()";

I got the same error:

Fatal error in query
ERROR:  syntax error at or near "exec" znak 1

Maciek