Subject Re: [firebird-support] RECREATE Procedure issue.
Author Mark Rotteveel
On 2016-03-17 15:49, Joje joje@...
[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:

> 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

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.