| Subject | Re: [firebird-support] RECREATE Procedure issue. |
|---|---|
| Author | Helen Borrie |
| Post date | 2016-03-17T18:18:34Z |
Friday, March 18, 2016, 3:49:15 AM, Joje wrote:
I am facing a issue with 'RECREATE' procedure. Problem: 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' |
See
http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-procedure.html#fblangref25-ddl-proc-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
or
2) you have a very old version of your third-party SQL tool that does not recognise it
HB