Execute your procedure from an anonymous block, using country_id 90.
Re-execute the procedure from the anonymous block, this time using country_id 95.
Retrieve your procedure code from Saved SQL and modify it to trap the NO_DATA_FOUND
exception in an exception handler. Execute the modified procedure using country_id 95 again.
Now what happens?