Oracle Plsql has encountered a plsql when running update or delete, or is causing the code to run out of SQL when it dies.
Encountered in the development of this problem, the original SQL copied out, run in Plsql, the SQL itself is spelled correctly, but there is the case of Plsql card death,
In the code, where you run SQL, you break the point debug and find that you are running SQL and still not responding. After searching the data online, the reason for the result is that
there may be no commit,oracle to lock the record when Plsql developer runs update.
Can be solved by the following methods:search for locked records firstSQL codeSELECT S.sid, s.serial# from V$locked_object Lo, dba_objects ao, v$session s WHERE ao.object_id = lo.object_id and lo. session_id = S.sid; and then delete the locked record .SQL code
ALTER System KILL Session ' sid,serial# ';
Through the SQL above. The problem finally conquered!
Summarize down to hope for everyone to develop helpful.
Oracle Plsql How to troubleshoot when running update or delete