Error when inserting/updating TimeStamp array with null valu
Posted: Fri 01 Jun 2012 11:18
Hi,
I'm trying to insert or update a TimeStamp Without Time Zone column in the database with ´null´ values. But each time I execute the C# code, it throws the following error inside a Devart.Data.PostgreSql.PgSqlException class exception: {Error: 08P01: insufficient data left in message}
As an example, I have the following C# source code:
What I'm trying to do is quite simple: I could have 'null' values that I need to update through a stored procedure into a table using arrays for "bulk processing". So far, for debugging purposes the stored procedure is empty (no body).
Any help you could provide would be greatly appreciated.
Technical information:
- Microsoft Windows System
- PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit
- Devart dotConnect for PostgreSQL 5.80.350.0
I'm trying to insert or update a TimeStamp Without Time Zone column in the database with ´null´ values. But each time I execute the C# code, it throws the following error inside a Devart.Data.PostgreSql.PgSqlException class exception: {Error: 08P01: insufficient data left in message}
As an example, I have the following C# source code:
Code: Select all
public void Update()
{
using (PostgreSQLCommand updateCommand = new PostgreSQLCommand((PgSqlConnection)transaction.Connection, GetStoredProcedureName(@"Schema", @"Update")))
{
// The following parameter will have 26 'null' values/elements.
updateCommand.Command.Parameters.Add(new PgSqlParameter(@"date", PgSqlType.Array) { Value = new PgSqlArray(PgSqlType.TimeStamp, 1, 26) });
updateCommand.ExecuteNonQuery(true);
}
}
Any help you could provide would be greatly appreciated.
Technical information:
- Microsoft Windows System
- PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit
- Devart dotConnect for PostgreSQL 5.80.350.0