Re: Request of an opinion about a procedure - (where current of)

very bad. What's your point?

Francesco Dini wrote:
>
> 6 CURSOR C1 IS
> 7 SELECT *
> 8 FROM LFBAGARR
> 9 WHERE POSTAZIONE = I_POSTAZIONE
> 10 FOR UPDATE;
> 11 C1%ROWTYPE
> .....
>
> 33 BEGIN
> 34 OPEN C1;
> 35 FETCH C1 into REC1;
> 36 WHILE C1%FOUND LOOP
>
> ....
>
>
> 179 DELETE LFBAGARR WHERE CURRENT OF C1;
> 180 commit;
> 181 close c1;
> 182 open c1;
> 183 END IF;
> 184 FETCH C1 INTO REC1;
> 185 END LOOP;
> 186 CLOSE C1;
> 187 END;
>
> For me it' is a bad procedure: for you ?
>
  Received on Thu Aug 10 2000 - 00:00:00 CEST