• Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem with SQL Developer

 
Fred Victa
Ranch Hand
Posts: 192
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: 614
9
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: 192
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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!