SELECT CALL_DIVERTED_NUM,SMS_DIVERTED_NUM,SMS_STRING,SMS_STATUS INTO :call_diverted:call_diverted_ind,:sms_diverted:sms_diverted_ind, :subs_sms_string:subs_sms_string_ind,:subs_profile FROM MCA_SUB_PROFILE WHERE MOBILENUM = :sqlv_mobilenum;I am getting the error "NO_DATA_FOUND." What do I have to do to solve this problem? I am using a three-machine architecture; one is our database machine and the other two are application servers. On one of my machines it's running but on the other machines I am facing this problem. Please suggest a solution. Manually this query is running fine -- what's wrong with what I'm doing?
This was first published in February 2007