Subject Re: [firebird-support] RECREATE Procedure issue.
Author Helen Borrie
Re: [firebird-support] RECREATE Procedure issue. Hello Joje,

Friday, March 18, 2016, 3:49:15 AM, Joje wrote:

I am facing a issue with 'RECREATE' procedure.

I have a stored procedure that uses 'RECREATE Procedure', this procedure does not execute properly when executed in EMS SQL manager for IB and Firebird.
Dont know why....... :( every time i execute it. Procedure execution stuck as declaration variable whenever using 'RECREATE', however when I use 'ALTER' procedure gets executed without any error. There is no documentation provided in firebird site about 'RECREATE'


It is probably a dependency issue or, perhaps,

1) You are using a very old version of Firebird that does not support RECREATE PROCEDURE
2) you have a very old version of your third-party SQL tool that does not recognise it