Hi,
I have a proc, but I can't retrieve a value with return :

CREATE PROCEDURE "PROC_INS_PERI"
(
"SHP_NAME" CHAR(50) CHARACTER SET WIN1252,
"PERI_TYPE" INTEGER,
"IDENT" CHAR(40) CHARACTER SET WIN1252
)
RETURNS
(
"ID_TEMP" INTEGER
)
AS
BEGIN
ID_TEMP = GEN_ID(GEN_PERI, 1);
INSERT into PERIMETRE
(ID_PERI,SHP_URL,CODE_TYPE,CODE_IDENT)
values(:ID_TEMP ,:SHP_NAME,:PERI_TYPE,:IDENT);
END


and I try to retrieve ID_TEMP with
select * from PROC_PERI_INS ('aa',1,'bb');


GEN_PERI is well upgraded,
The insert in Perimetre is successfull,
but I have nothing in the result of the select query ???

an Idea ?

hanks