Raigo wrote:

>How to put inside a selectable Stored Procedure another Stored Procedure?
>I have following procedure. problem here is that only one row is
>returned from there (there is suppose to be lot more). What may be wrong
>here?
>
>CREATE PROCEDURE sp_toopaev_tunnid
>RETURNS(
>fkood VARCHAR(10),
>isikid VARCHAR(11),
>too_tegevus VARCHAR(2),
>algus date,
>lopp date,
>tootatud_oosel double precision,
>tootatud_paeval double precision,
>tootatud_ohtul double precision)
>AS
>BEGIN
>for select fkood, isikid, too_tegevus, algus, lopp from v_toopaev into
>:fkood, :isikid, :too_tegevus, :algus, :lopp
>DO
>select tootatud_oosel, tootatud_paeval, tootatud_ohtul from
>SP_TOOPAEV_TUNDE(:algus, :lopp) into :tootatud_oosel, :tootatud_paeval,
>:tootatud_ohtul;
>SUSPEND;
>END
>
>
>

Hi !

Maybe the problem is inside SP SP_TOOPAEV_TUNDE, put the code of this too...


see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br