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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.