Oracle notfound is null

February 27, - am UTC. I do not "count" to see if I should do something. I just try to do it and if there is no data to process, so be it. Hi Tom, Good Morning. Or is this attribute useful? Please clarity. Thanks, Giridhar Kodakalla. July 17, - am UTC.

I would consider it being there as a completeness thing. All cursors have attributes, isopen and so on. It is there because in general all cursors "have it" Since the implicit cursor is just a cursor after all, it has that attribute. It's usefulness in real life? Probably none that I can think of. Alex, February 17, - pm UTC. Hello, I'm having an issue with nested blocks that can possible return no rows from my singleton selects.

It's being caught in the wrong place. Thank you. February 18, - am UTC. No, it is not. Alex, February 18, - pm UTC. That's interesting. I may have found an enormous bug in toad's procedure editor then.

When I step through the code, it's dropping into the first exception block. Alex, February 21, - am UTC. Ok I confirmed it. TOAD version 8.

I ran my procedure from sqlplus and it was being caught in the correct spots. Thanks for setting me straight. Hi Tom, Why is the following procedure fails?? I thought I can use an implicit cursor like this. Any ideas?? October 11, - pm UTC. I understood your answers here but If I am trapping all other no data found possibilities in my code. LAST are defined how could I get a no data found?

My code goes through 2,, records then raises a no data found at the line noted below. December 14, - pm UTC. I have a problem with a cursor attribute. To be safe, use the following EXIT statement instead:.

In answer to your question there is no "default" value. The value at that point is null; I guess you could call this the default if you wanted. After the first fetch of a cursor the value will either be true of false depending on whether any rows were returned. After the cursor is closed the "variable" no longer exists. To quote from the 11gr2 documentation :. The 10g documentation has a useful table that demonstrates this.

However, there does appear to be a direct contradiction in the Oracle documentation. The 11g documentation also has something similar to what you've described. The wording of which seems to directly contradict the above assertion. The 10g documentation is more explicit and slightly differently worded. This isn't a direct contradiction. To be safe, you might want to use the following EXIT statement instead:. I don't know in what situations a fetch would not execute successfully; I've asked the question.

Patrick - I learn something new every day. Thank you! Add a comment. Active Oldest Votes. Patrick Bacon Patrick Bacon 4, 1 1 gold badge 24 24 silver badges 31 31 bronze badges.

The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta.