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