Jorge,
I have done a SELECT FROM instead of an EXECUTE PROCEDURE when I do not need all the fields returned in a stored procedure. This will only work I think if the SP has a SUSPEND; in it. SELECT R_PRINC_BAL, R_FEE_BAL FROM SPS_CASE_CUR_BAL(:ACCT_ID, :CASE_ID, NULL, 1) INTO :PRINCIPAL_BAL, :FEE_BAL; Mike From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Friday, August 21, 2015 1:08 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] RETURNING_VALUES optional variables? I´m calling a stored procedure (SP1) from inside another SP (SP2). SP2 has three output vars, but when calling it from SP1 I only need one value. It's possible to "omit" 2nd and 3rd parameters when using EXECUTE PROCEDURE? (Right now I´m using SP1 local variables whose values are never used). Thanks! -- Jorge Andrés Brugger Departamento de Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbrug...@dasu.com.ar Website: www.dasu.com.ar "Aquel que tiene una opinión de sí mismo, pero depende de la opinión y los gustos de los demás, es un esclavo" (Friedrich Gottlieb Klopstock) -- Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo. [Non-text portions of this message have been removed]