JDBC - System/Application Acknowledgement

Hi,

my scenario is IDoc -> XI -> JDBC (Oracle DB)

I use a trigger on my db table. I would like to know whether the data processing on my Oracle db was successful or not. Is system acknowledgement sufficient or have I to realize it via application acknowledgement (by means of BPM or stored procedure)? Where ends system acknowledgement and where starts application acknowledgement in this case?

Thanks in advance

Christian