// *Cause: DML operation like insert, update, delete or select-for-update
// cannot be performed inside a query or under a PDML slave.
// *Action: Ensure that the offending DML operation is not performed or
// use an autonomous transaction to perform the DML operation within
// cannot be performed inside a query or under a PDML slave.
// *Action: Ensure that the offending DML operation is not performed or
// use an autonomous transaction to perform the DML operation within
// the query or PDML slave.
在一个select 语句中调用函数引起的,使用自治事务可以解决
pragma autonomous_transaction;
本文探讨了在SELECT语句中调用函数导致的问题,特别是当这些操作涉及到DML如INSERT、UPDATE等时。文章提供了使用自治事务来解决这类问题的方法。

8999

被折叠的 条评论
为什么被折叠?



