On 2016-03-17 15:49, Joje [email protected] [firebird-support] wrote: > Hi All, > 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',
Could you explain what happens: do you get an error, does it hang, or does it do nothing? > however when > I use 'ALTER' procedure gets executed without any error. There is no > documentation provided in firebird site about 'RECREATE' But there is: http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-procedure.html#fblangref25-ddl-proc-recreate > Could some tell me whether they have faced issues with 'RECREATE' or > have fixed this kind of issue. > > Thanks in Advance would appreciate your help in this matter. You might want to use CREATE OR ALTER PROCEDURE instead http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-procedure.html#fblangref25-ddl-proc-crtoralter The difference is that recreate drops and then creates the procedure, while CREATE OR ALTER creates a procedure if it doesn't exist or otherwise alters the procedure. Mark
