3 Replies Latest reply on Jun 3, 2015 9:08 AM by Rajesh123

    ORA-06502: PL/SQL: numeric or value error: character to number conversion error

    Rajesh123

      Hi all,

       

      In the Declaration

      1)v_no varchar2(1000);

      2)c_rec.order_no is number data type

       

      In the for loop

      v_no:=NULL

      v_no:= v_no||lpad(NVL(c_rec.order_no,' '),15);

       

      Getting ORA-06502: PL/SQL: numeric or value error: character to number conversion error

       

      If i remove the NVL from the above code so it is fine at runtime

       

      Please help me

       

      Thanks