|Subject||Re: [firebird-support] RECREATE Procedure issue.|
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