App Design: Logging to CLOB field

10gR2/Solaris 8

In my application, I have concurrent sessions running process x and need to write log....
what do you think of writeappending log lines to a CLOB field ? (via AUTONOMUS TRAN)

say i have table;

SQL> desc t_putdata_stat

PROCESS_ID         NUMBER
STATUS                  NUMBER
LOG                         CLOB

so I end up with a "single" log for each PROCESS

do you see any issuey with this ?
thanks Received on Thu Sep 06 2007 - 15:51:40 CDT