Want to ignore exception in a begin-end block
552969Dec 10 2008 — edited Dec 13 2008Hi,
For a given plsql block (inside a procedure or function for example) I want to ignore a certain oracle exception. Ignore as in, it should not be raised at all.
What I want to do is something like this -
begin (tell somehow to NOT raise NO Data Found (NDF) )
bq. select <something> \\ into <some Variable> \\ from <somewhere>; \\ if sql%rowcount = 0 \\ then \\ +<take action meant for NDF>;+ \\ end if;
end;
Any Ideas ?
cheers
raghav..