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: jbrugger@...
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]