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', however when I use 'ALTER' procedure gets executed without any error. There is no documentation provided in firebird site about '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.