How to check SQL status code after performing a 'Select' ?

[aakumar]

How can I check if  an 'Oracle 'select'  snap returned any results? 

I need this to determine if I should set the output to "Customer not found"   when results are null.