Strange Issue in PL/SQL Block

Hi Friends,

We are using the below query inside our PL/SQL block:

SELECT length(MOBILE_NUM) INTO v_COUNT FROM GSM_PROFILE WHERE MOBILE_NUM=i_SDCA_MDN;

the above query returns "NO DATA FOUND" exception.

But while running the same query in SQL window (below one) perfectly it return values

SELECT length(MOBILE_NUM) FROM GSM_PROFILE WHERE MOBILE_NUM='1111111111';

Output : 10

We have verified our input parameter in stored procedure and printed the same in DBMS_OUTPUT window. The input passing to the stored procedure is perfect. Eventhough its throwing "NO DATA FOUND" exception.

CREATE TABLE GSMPROFILE