ORA-14552 cannot perform a DDL, commit or rollback inside a query or DML Cause: DDL operations like creation tables, views etc. and transaction control statements such as commit/rollback cannot be performed inside a query or a DML statement. Action: Ensure that the offending operation is not performed or use autonomous transactions to perform the operation within the query/DML operation.
问题解决了,和大家分享一下,我发现是我在前台调用调用时是使用 select sp_test() into :xxx from dual; 这样的语句,可能是oracle将这句话当成是查询了,后来将那个函数也改成过程,在前台调用那个过程就没有问题了!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货