Is there table level commit?# Database - 数据库
r*l
1 楼
I am new to PL/SQL so if this question is stupid, don't blame me.
I am writing a PL/SQL procedure to operation on a table, say T_OPR.
I want to write the log information to another table, say T_LOG.
The operations on T_OPR should be rollback-ed if there is a single error.
When this happened, I still want to info in T_LOG to be committed.
If there any way to do it? Thanks a lot.
I am writing a PL/SQL procedure to operation on a table, say T_OPR.
I want to write the log information to another table, say T_LOG.
The operations on T_OPR should be rollback-ed if there is a single error.
When this happened, I still want to info in T_LOG to be committed.
If there any way to do it? Thanks a lot.
