Subject Re: [firebird-support] Dropping a Table causes "OBJECT IS IN USE"
Author Helen Borrie
At 01:51 PM 17/05/2006, you wrote:
>Trying to drop a table which I created in the same session
>I get the below error.
>What can I Do
>- the table is external
>- the table had a stored procedure using it.
>- i have successfully dropped the stored procedure.
>ISC ERROR CODE:335544345
>lock conflict on no wait transaction
>unsuccessful metadata update
>object MYTABLE is in use

Stored procedures (and triggers) that you alter or drop nevertheless
remain cached until the last user logs, what you can do is
log everyone out (Superserver) or simply log out yourself if it's Classic.