Null operation

From: Jenda Krynicky <Jenda_at_Krynicky.cz>
Date: Wed, 08 Sep 1999 16:46:34 GMT
Message-ID: <1103_936809194@prague_main>

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:46:34 CDT