Re: [PERFORM] Calling a SP from Curosor loop

On 29 Jun 2006 10:00:35 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I have SP, which has a cursor iterations. Need to call another SP for every loop iteration of the cursor. The pseudo code is as follows.. i would suggest converting your code to pl/pgsql and reposting. that look awfull

[PERFORM] Calling a SP from Curosor loop

I have SP, which has a cursor iterations. Need to call another SP for every loop iteration of the cursor. The pseudo code is as follows.. Create proc1 as Begin Variable declrations... declare EffectiveDate_Cursor cursor for select field1,fld2 from tab1,tab2 where tab1.effectivedate