I am getting an "Internal Error" when calling a web service within a procedure. The majority of the time, when getting this error, it is due to no rows being returned from the service.
So, what would be the best way to capture this error?
1. Should I parse out the xml soap message and look for the element <faultstring>?
2. Or is there an exception message that I can use to capture these errors.
What I want to do, is that when there are no rows being returned, is to raise an exception like
"no_data_found" if that is possible.
Here is the soap response message that comes back, when no rows are being retrieved via the
web service call.
<?xml version = '1.0' encoding = 'UTF-8'?>