Re: Null operation

Hey Jenda,

     In PL/SQL, I believe you can use the NULL statement. For your procedure would work like:

EXCEPTION WHEN NO_DATA_FOUND THEN
   NULL;
 END;
END LOOP; Jay!!!

Jenda Krynicky wrote:

> A stupid question to most of you ... how do I say NOOP (Null operation) in PL/SQL?
>
> I have something like this in a procedure
>
> FOR rec IN c1 LOOP
> begin
> select ... into ... from table where ...;
>
> insert into othertable (...) values (...);
> end;
> END LOOP;
>
> The select often fails and if I do not catch the exception the procedure exits.
> Or so it seems.
>
> So I would like to do something like this :
>
> FOR rec IN a_cursor LOOP
> BEGIN
>
> select ... into ... from table where ...;
>
> insert into othertable (...) values (...);
>
> EXCEPTION WHEN NO_DATA_FOUND THEN
> NOOP;
> END;
> END LOOP;
>
> I realy do not need to do anything in case of the exception. I only want to move on to another record.
>
> I'm sure I am missing something basic.
>
> Thanks a lot, Jenda
> http://Jenda.Krynicky.cz
>
> P.S.: I'd be grateful if you CC: me the reply, thanks.
Received on Wed Sep 08 1999 - 11:42:11 CDT