At 07/15/2002 10:54 AM (Monday), jef.mony@... wrote:

>I have a proc, but I can't retrieve a value with return :
>[snip]
>and I try to retrieve ID_TEMP with
>select * from PROC_PERI_INS ('aa',1,'bb');

Rather than using SELECT, you execute this type of procedure using EXECUTE
PROCEDURE X() RETURNING_VALUES Y. Check the documentation for EXECUTE
PROCEDURE.