Re: Calling a SPL that returns LIST(...)

If I understand you well, you have to use RETURN WITH RESUME J. -----Original Message----- From: Adam Tauno Williams <adam@morrison-ind.com> To: informix-list@iiug.org Date: Mon, 17 Jan 2005 10:49:57 -0500 Subject: Calling a SPL that returns LIST(...) In the field clause of an SELECT statement one can call a SPL such as - SELECT ....p_get_ref_cost("ME", xr_oem_code, xr_oem_partcode) as ref_cost .... - and get that value back for each row. It works great so long as the SPL returns ONE value (in the above case a FLOAT). Is it possible, and if so how, to call a SPL in the same manner that returns multiple values. The signature looks like - CREATE PROCEDURE p_get_ref_list(i_company_id char(2), i_oem_code char(4), i_oem_partcode char(20)) RETURNING CHAR(4), FLOAT;- I'd like to do something like - SELECT ... p_get_ref_list("ME", xr_oem_code, xr_oem_partcode) as (ref_vendor, ref_price).... - only that doesn't work. sending to informix-list Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list