• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with SQL Developer

 
Fred Victa
Ranch Hand
Posts: 190
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Tapas Chand
Ranch Hand
Posts: 583
8
BSD Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am not sure, but I guess this will solve the problem.
Login into Oracle from command line and drop the procedure. First keep the backup of the store procedure.
 
Fred Victa
Ranch Hand
Posts: 190
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tapas Chand wrote:I am not sure, but I guess this will solve the problem.
Login into Oracle from command line and drop the procedure. First keep the backup of the store procedure.


I'll try that.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic