Re: pl/sql table and commit

Actually I dont know why the COMMIT I incidently used changed anything, but I have identified the fragment of code which does not work:

This is the old code which fails:

               I :=0;
               LOOP

                 Valid := True;
                 FETCH TMPCUR INTO R1 ;
                 EXIT WHEN TMPCUR%NOTFOUND;
                 IF NOT(ASP42.tab_ClinicUser.EXISTS(R1.r_clinic)) THEN
                   DBMS_OUTPUT.PUT_LINE('!clinique invalide '
                                 ||TO_CHAR( R1.r_clinic));
                   Valid := False;
                 END IF;
                 IF Valid  THEN
                   i := i + 1;
                   Tab_sessionSector(i):= R1 ;
                 END IF;

               END LOOP;

This is the code which now works:
		iCount := 1;
		Tab_sessionSector.Delete;

		LOOP
		FETCH TMPCUR INTO R1;
		   EXIT WHEN TMPCUR%NOTFOUND;
		   iCount := iCount + 1;
		   Tab_sessionSector(iCount) := R1;
		END LOOP;

Less pressure now, but the mystery thickens. This usually bites you pretty bad later... Received on Wed Nov 16 2005 - 14:06:48 CST