PL/SQL %NOTFOUND?

[ThatRickGuy]

Just wondering if anyone else has run into this...

I was having a heck of a time getting a PL/SQL statment to work it had a loop in it using the following statement for it's exit:

EXIT WHEN update_cursor %NOTFOUND;

Now, this seems to make rather good sence. BUT, it never worked right. My code would always exit the loop. So, I broke down and RTFB. If this book is right, then the system variable %NOTFOUND returns TRUE if the is a record found, and FALSE if there is no record found. Am I on crack? or did someone make a little error in their naming conventions?

-Rick

 

[ThatRickGuy]

A quick update. %NOTFOUND is correctly designed so that it returns TRUE if nothing is found and FALSE if anything is returned, the problem wound up being in my query. the book "Oracle Desk Reference" by Guy Harrison has a typo. (Never trust a man named Guy)

-Rick