Q

NO_DATA_FOUND error with query

I am using this query in Pro*C and getting the error "NO_DATA_FOUND." It works fine on one machine but not the others.

I am using this query in Pro*C:
 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?
Probably the most obvious thing to look for is to ensure that your variable 'sqlv_mobilenum' contains a valid value. And ensure that its datatype matches the datatype of the MOBILENUM column.
This was first published in February 2007

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close