I am using the AdoNetAppender and I am calling a sql server stored proc.
I have a parameter
<parameter>
<parameterName value="@pId" />
<dbType value="Int32" />
<layout type="log4net.Layout.RawPropertyLayout">
<key value="%property{Id}" />
</layout>
</parameter>
I pass in 0 and when the logger is executed the stored procedure adds the
exception and as part of the stored proc the @pId paramter is an output
parameter and it will return the ID of the record that it has created in the
error table. The idea is to then display this ID to the user so they can
use as part of their reporting process to support teams.
The issue is I do not know how to how to pass this value from the stored
proc back to the configuration parameter above.
If anyone could help out would appreciate.
--
View this message in context:
http://old.nabble.com/Read-a-value-from-sql-server-into-log4net-parameter-tp28803512p28803512.html
Sent from the Log4net - Users mailing list archive at Nabble.com.
