Try

Select * from DOC_IESIRE_MOD_CALC_6(:id_document_in)

Elkins

-----Mensaje original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] En nombre de Tiberiu Horvath
Enviado el: sábado, 15 de agosto de 2009 01:55 p.m.
Para: firebird-support@yahoogroups.com
Asunto: [firebird-support] call a stored procedure

Hi all,

Is there a way to get all the returned fields from my procedure ? (header
follows)

id_document_in comes from a "document" table

I would like to have all the returned fields from the procedure, with one
call, something like this :

select
document.id_document,
DOC_IESIRE_MOD_CALC_6(document.id_document) /*all the fields */
from document


CREATE OR ALTER PROCEDURE DOC_IESIRE_MOD_CALC_6 (
id_document_in integer)
returns (
val_pret_furn decimal(18,4),
val_marfa_iesita decimal(18,4),
val_iesire_marfa_incl_tva decimal(18,4),
val_marfa_iesita_incl_tva decimal(18,4),
val_pret_furn_valuta decimal(18,4),
val_iesire_marfa decimal(18,4),
val_fara_tva decimal(18,4),
val_tva decimal(18,4),
cantitatea decimal(18,4),
val_tva_5 decimal(18,4),
val_tva_9 decimal(18,4),
val_tva_19 decimal(18,4),
val_tva_5_marfa decimal(18,4),
val_tva_9_marfa decimal(18,4),
val_tva_19_marfa decimal(18,4),
id_tip_servicii integer,
val_servicii decimal(18,4),
val_servicii_incl_tva decimal(18,4),
ad_com_lei decimal(18,4),
ad_com_valuta decimal(18,4),
val_incl_tva decimal(18,4),
val_incl_tva_valuta decimal(18,4),
val_pret_vanz_valuta decimal(18,4))




Thank you,

Tiberiu



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links