Wrong ORA 8192 error
Posted: Wed 05 Jun 2013 12:00
Hello,
Today I've found a bug in Timestamp with time zone Parameter handling:
At first create the following Stored Procedure in your DB, it doesn't need to do anything:
And then run the following code:
This will fail with an "ORA-08192: Flashback Table operation is not allowed on fixed tables" error, which has pretty much nothing in common with this error.
Problem seems to be with TimeStampTZ, if the param is changed to TimeStamp everything works fine (or raises the correct/expected errors and problems).
Tests were done with Devart 7.7, Ora 11.2.0.3 client/server;
BR
Today I've found a bug in Timestamp with time zone Parameter handling:
At first create the following Stored Procedure in your DB, it doesn't need to do anything:
Code: Select all
CREATE OR REPLACE PROCEDURE ORA8192SAMPLE (
P_TIMESTAMP TIMESTAMP WITH TIME ZONE
)
IS
BEGIN
null;
END;
Code: Select all
string connectionString = "Data Source=YOURSERVER;User Id=YOURUSER;Password=YOURPASS";
string commandText = "ORA8192SAMPLE";
using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
using (OracleCommand commandFailing = connection.CreateCommand())
{
commandFailing.CommandText = commandText;
commandFailing.CommandType = CommandType.StoredProcedure;
commandFailing.PassParametersByName = true;
commandFailing.Parameters.Add("P_TIMESTAMP", OracleDbType.TimeStampTZ);
commandFailing.Parameters["P_TIMESTAMP"].OracleValue = new OracleTimeStamp(DateTime.MinValue);
commandFailing.ExecuteNonQuery();
} connection.Close();
}
Problem seems to be with TimeStampTZ, if the param is changed to TimeStamp everything works fine (or raises the correct/expected errors and problems).
Tests were done with Devart 7.7, Ora 11.2.0.3 client/server;
BR