This two days in order to achieve a user's need, do a few stored procedures and triggers, manipulate the data in two databases, frequently, ora - 14450: trying to access is already in use of the transaction the temporary table, baidu also checked the this problem, the solution is kill off session, just want to ask everybody a great god is there any way to avoid this kind of circumstance happening ~!

CodePudding user response:

No one is

CodePudding user response:

Information is too little, you should have your table structure, trigger, and code to stick out of the process, everyone is likely to help you,