SOA Uses 10.2 POLite.
Please refer to the link for more debuginfo.
Set OLITE_SQL_TRACE=TRUE in c:\windows\polite.ini file ,
The sql trace info is written to c:\windows\system32\oldb_trc.txt
OLITE_SQL_TRACE = TRUE
SQL trace output is dumped to a trace file named
oldb_trc.txt in the current working directory of the database process. For a database service on Windows, Windows NT or the Oracle Database Lite daemon for a Linux platform, the current working directory is specified by the
wdir parameter during the database startup service or daemon. Applications that use an embedded connection to connect to the database contain a working directory. This working directory is the application working directory. To implement the tracing feature, the database process must contain permissions to create the trace file in the current working directory. The trace output is always included in the trace file. If the trace file does not exist, it is created automatically.