Open
Description
I use Log4j for logging sql statements. However I couldn't find a way for logging values of out parameters retruned from stored procedure/function.
Below sample logs. SOME_PROCEDURE accepts 1 in parameter. Rest of parameters are OUT parameters. As we can see out parameters are not logged.
2013-10-31 14:47:19:210 SessionID:Uqz9u0e56a3a24099b49b516472a7 DEBUG WebContainer : 3 com.MapperClass - ==> Preparing: {? = call SOME_PROCEDURE( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )}
2013-10-31 14:47:19:210 SessionID:Uqz9u0e56a3a24099b49b516472a7 DEBUG WebContainer : 3 com.MapperClass - ==> Parameters: productId(String)