Subject Re: [IBO] TIB_StoredProc
Author Harald Klomann
Guido,

there is a select in your proc !

select FDID from FOLLOWUPDISCOUNTS where FDDCID=:DCID into :FDID;

Harald


guido.klapperich@... wrote:

> I have a stored procedure, that looks like
> CREATE PROCEDURE P_APPROVE_DISCOUNTS (
> DCID INTEGER)
> AS
> declare variable FDID Integer;
> begin
> /* √úbernimmt die beantragten Discount-Werte */
> update DISCOUNTS set DCDISCOUNT=DCDISCOUNTNEW, DCDISCOUNTNEW=0 where
> DCID=:DCID;
> update DISCOUNTS_MP set DMDISCOUNT=DMDISCOUNTNEW, DMSUM=DMSUMNEW,
> DMDISCOUNTNEW=0, DMSUMNEW=0 where
> DMDCID=:DCID;
> select FDID from FOLLOWUPDISCOUNTS where FDDCID=:DCID into :FDID;
> update FOLLOWUPDISCOUNTS_MP set FMDISCOUNT=FMDISCOUNTNEW,
> FMDISCOUNTNEW=0
> where FMFDID=:FDID;
> end
>
> When I try to execute the SP with a TIB_StoredProc, I get the error
> 'multiple rows in singleton select', but I the SP do only updates. The
> property StoredProcForSelect is false.
>
> Guido.
>