At 09:44 PM 4/12/2005 +0530, you wrote:

>Hi,
>
> In the followng SP, the SQL statement on line 38
>
> UPDATE account_heads SET ageing_id = :iAgID, ageing_balance = :dBaln
> WHERE CURRENT OF cT1;
>
> gives an 'unknown cursor error'
>
> So I had to change it to
>
> UPDATE account_heads SET ageing_id = :iAgID, ageing_balance = :dBaln
> WHERE company_id = :dCID AND account_id = iAcCd;
>
>
> to avoid the error. Is this a bug ?

Not a bug. You are trying to update a row in a joined set. That's not
possible.

./heLen