Hi all,

 

I noticed that with Classic 2.5, you can get “object in use” when trying to modify a

stored procedure that’s been previously executed, see also:

 

 

When using “wait” on the transaction to save the procedure, instead of “nowait”,

the problem goes away.

 

Is it safe to always use “wait” on such transactions?

 

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!