r*****l
发帖数: 2859 | 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. | n********a
发帖数: 68 | 2 Use autonomous transaction.
" target="_blank" class="a2">http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/06_ora.htm#27440
【在 r*****l 的大作中提到】
: 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.
| r*****l
发帖数: 2859 | 3 Thanks a million!
This is the right kind fo information that I need.
【在 n********a 的大作中提到】
: Use autonomous transaction.
: " target="_blank" class="a2">http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/06_ora.htm#27440
|
|
