select *
from
documente,
DOC_IESIRE_MOD_CALC_6(documente.id_documente)
where
documente.id_documente between 1000 and 1500

generates a " The cursor identified in the update or delete statement is not
positioned on a row. No current record for fetch operation." error.


Tiberiu

--------------------------------------------------
From: "Tiberiu Horvath" <exact@...>
Sent: Saturday, August 15, 2009 8:54 PM
To: <firebird-support@yahoogroups.com>
Subject: [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
>
>
>