Hi all,

Suppose my v_headers.bill getting more than 5 characters i am getting ORA-01403: no data found.

For this i have increased the size as VARCHAR2(20), it is working dine.

But i want to use substr in the below code , where , why and how can i use? Please explain me.

DECLARE 
    v_item_number VARCHAR2(5); 
BEGIN 
    IF v_headers.prime_number = '12345678' THEN 
      v_item_number := v_headers.bill; 
    ELSE 
      v_item_number := NULL; 
    END IF; 
END; 

how utterly lame, lazy, & disrespectful is the post above after more than 1 year posting here about twice a day and still no Oracle version included with this thread.

01403, 00000, "no data found"
// *Cause: No data was found from the objects.
// *Action: There was no data from the objects which may be due to end of fetch.
[oracle@localhost ~]$

ORA-01403 results from a FETCH from cursor, but no cursor exists in posted code.
Please maintain at least 2 meter separation from any keyboard which will benefit everyone here.