Hi,

The following Generator returns NULL when I use following SQL

SELECT NEW_EVRAKNO FROM GPR_MALZEMEHAREKET_EVRAKNO


CREATE PROCEDURE GPR_MALZEMEHAREKET_EVRAKNO
RETURNS (
NEW_EVRAKNO VARCHAR (20))
AS
BEGIN
NEW_EVRAKNO = 'EN' || GEN_ID(malzemehareket_evrakno, 1);
END

But, If I use Trigger there is no problem,

Do you know? What is the reason?

[Non-text portions of this message have been removed]