posted 2 years ago
I accidentally created a stored procedure with an infinite loop in SQL Developer. I ran that stored procedure and there was an infinite loop so I terminated my session with SQL Developer. After this happened, I've had problems compiling my package that is in SQL Developer. Every time I try to compile it, SQL Developer locks up. I tried to drop the package that the stored procedure with the infinite loop is in, but SQL Developer keeps on locking up.