You should not get an error but you should include an exception Handler to Include WHEN NO DATA FOUND, perform an action.

Take you select statement and look at what is in the WEHRE Clause.

Examine the Data closely and determine what in the Where Clause is causing no data to be returned.