Subject RES: [firebird-support] object is in use
Author Fabiano - Desenvolvimento SCI

Also, FB 2.5.0 has problems with this. If you use this version upgrade to 2.5.1 or above.

 

De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Enviada em: segunda-feira, 18 de agosto de 2014 16:47
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] object is in use

 

 

Hello Carlos.

Thanks.

I am using IBExpert to run an 'CREATE OR ALTER PROCEDURE MY_PROCEDURE....."

That´s why I am not understending what can avoid to execute this.

This PROCEDURE just returns a value from a table.

I should be able to drop and insert a PROCEDURE at anytime into the DB. Should not I?


Em 18/08/2014 16:40, 'Carlos H. Cantu' listas@... [firebird-support] escreveu:

 

When you start a transaction you determine the wait mode. Where you set this depends on the component/access technology you are using.

Carlos
Firebird Performance in Detail -
http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br





Hi Carlos.

Where do I chage it?

Hugo

Em 18/08/2014 15:06, 'Carlos H. Cantu'
listas@... [firebird-support] escreveu:
 
To avoid such error, try to change the DDL transaction parameter to
WAIT instead of NO WAIT.

Carlos
Firebird Performance in Detail -
http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br

HEhmcfs> Hello.

HEhmcfs> IBExpert shows the message:

HEhmcfs> lock conflict on no wait transaction
HEhmcfs> unsuccessful metada update
HEhmcfs> object MY_PROCEDURE is in use

HEhmcfs> How can I see 'who' is using the procedure?


--


Atenciosamente,

Hugo Eyng



-- 
  
  
Atenciosamente,
  
Hugo Eyng