title: oracle plsql stored procedure error handling ora-6502
body: <pre><code>create procedure about_emp(p_empno in number,p_ename out varchar2)
  is
  begin
  select ename into p_ename from emp
  where empno=p_empno;
  exception
  when no_data_found then
  dbms_output.put_line('your id not available');
  when value_error then
  dbms_output.put_line('enter exact data');
  end;
  </code></pre>
  
  <h1>execution</h1>
  
  <p>variable x varchar2(10);
  exec about_emp(4520,:x);</p>
  
  <h2>X</h2>
  
  <p>michel</p>
  
  <p>exec about_emp(1111,:x);
  you id not available</p>
  
  <p>exec abot_emp('a',:x);
  ERROR at line 1:
  ORA-06502: PL/SQL: numeric or value error: character to number conversion error
  ORA-06512: at line 1</p>
  
  <p>but normally in store procedure are display like
  ERROR at line 1:
  ORA-01403: no data found
  ORA-06512: at "SCOTT.about_emp", line 4
  ORA-06512: at line 1</p>
  
  <p>please find the error and give me the solution</p>