Are there any ways to view the SQL mapping statements?

[Lucy Fang]

Title: Are there any ways to view the SQL mapping statements?

Hi,

Are there any ways I can view the SQL mapping statements after created a dynamic SQL statement and passed all of parameters to it?

I have a dynamic SQL mapping statement with
        select * from campus where campuscode in #campusCode#
if I use campuscode in (03,04), it works good. But if I use the parameter campusCode replace the value, it doesn't work. I pretty sure the parameter value is "(03,04)".

The database I am using is Oracle and iBatis is SQL Map 2.0.

Thanks.

Lucy