Hey,
In some tables I work with Raw16 for representing Guid.
When working with db monitor, looking at executed sql statement parameters, instead of showing the value of the Guid or the values in the byte array it just shows "System.Byte[]".
It will be helpful if it will be fixed.
Thanks,
Kfir.
DB monitor and Raw
I have tried dotConnect for Oracle v 6.10.141, dbMonitor v 3.0.3, and Visual Studio 2010 SP1 v 10.0.40219.1.
Here is my output from the Parameters tab of DbMonitor:
Name - p1
Type - Input
Data Type - Raw
In Value - c729d794-c430-4406-9e13-0e0df230a3c1
Out Value - c729d794-c430-4406-9e13-0e0df230a3c1
Please tell us the versions of your dotConnect for Oracle (x.xx.xxx), dbMonitor (x.x.x), and Visual Studio, and the steps we should follow to reproduce the problem.
Code: Select all
// CREATE TABLE RAWTABLE (
// ID NUMBER(38),
// RAWCOLUMN RAW(16),
// CONSTRAINT PK_RAWTABLE PRIMARY KEY (ID));
[MTAThread]
static void Main(string[] args) {
OracleMonitor monitor = new OracleMonitor();
monitor.IsActive = true;
using (OracleConnection conn = new OracleConnection()) {
conn.ConnectionString = "server=orcl1120;uid=***;pwd=***;";
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into rawtable values (1, :p1)";
cmd.Parameters.Add("p1", OracleDbType.Raw).Value = Guid.NewGuid();
int i = Convert.ToInt32(cmd.ExecuteNonQuery());
}
}
Name - p1
Type - Input
Data Type - Raw
In Value - c729d794-c430-4406-9e13-0e0df230a3c1
Out Value - c729d794-c430-4406-9e13-0e0df230a3c1
Please tell us the versions of your dotConnect for Oracle (x.xx.xxx), dbMonitor (x.x.x), and Visual Studio, and the steps we should follow to reproduce the problem.
We have released the new 6.30.160 build of dotConnect for Oracle that includes the fix for the Guid problem. This build can be dowloaded from here (the trial version) or from Registered Users' Area (for users with active subscription only).
For the detailed information about the improvements and fixes available in dotConnect for Oracle 6.30.160, please refer to this announcement.
For the detailed information about the improvements and fixes available in dotConnect for Oracle 6.30.160, please refer to this announcement.