By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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?
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.