Thank you Thomas....
SUSPEND solves the problem..... Thats great

And Note for Thomas : " Sorry for my wrong direct email to you."

>
> CREATE PROCEDURE GPR_MALZEMEHAREKET_EVRAKNO
> RETURNS (
> NEW_EVRAKNO VARCHAR (20))
> AS
> BEGIN
> NEW_EVRAKNO = 'EN' || GEN_ID(malzemehareket_evrakno, 1);
> SUSPEND;
> END
>
>
> As said, the usage of SUSPEND depends on how you use/call
> the stored procedure.
>
>
> HTH,
> Thomas
>