Subject | Re: Dropping a Table causes "OBJECT IS IN USE" |
---|---|
Author | Adam |
Post date | 2006-05-17T03:59:05Z |
--- In firebird-support@yahoogroups.com, "robertgilland"
<robert_gilland@...> wrote:
Adam
<robert_gilland@...> wrote:
>You have a second transaction accessing MyTable.
> 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
>
> ISC ERROR MESSAGE:
> lock conflict on no wait transaction
> unsuccessful metadata update
> object MYTABLE is in use
>
Adam