Link to home
Start Free TrialLog in
Avatar of tlpacheco
tlpacheco

asked on

stored proc in firebird

hello,
I want to do a stored procedure in Firebird who is return 3 output variables.
my request sql is :
select v.nom_vendeur,  v.prenom_vendeur
from vendeur v, relvendeurgare r, gare g
where v.id_vendeur = r.vendeur_idvendeur
and g.id_gare = r.gare_idgare
and g.prefixe_id =:prefixeid
and v.num_serie_carte =:numserie

prefixeid and numserie were params in entry
I want for out :
present =1 if exist a rows return by the request
nom_vendeur
prenom_vendeur

tks u for u help
ASKER CERTIFIED SOLUTION
Avatar of Nick Upson
Nick Upson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial