Error Loging

[Mystique]

Hi
Does anybody know i can log the parameters that are called to a Oracle
stored procedure with C#?
I am using ODP Data Provider for the connection.

Regards,
Mystique

 

[Bill Block]

The easiest way may be to loop throught the command parameters
collection and manually build a string. For example:

StringBuilder sbQuery = new StringBuilder();
sbQuery.Append("Parameters ");
foreach (DbParameter param in command.Parameters)
{
sbQuery.Append("[");
sbQuery.Append(param.ParameterName);
sbQuery.Append("=");
if (param.Value != null)
{
sbQuery.Append(param.Value.ToString());
}
sbQuery.Append("]");
}

// Log(sbQuery.ToString());


Bill