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

From: DH <v_dh_at_hotmail.com>
Date: 21 Apr 2003 19:26:24 -0700
Message-ID: <f5042544.0304211826.19a7510a@posting.google.com>

Hi all,

I'm newbie in Oracle PL/SQL.
I'm trying a little PL/SQL as below in Oracle 8.1.7:

testplsql.sql:

---

set serveroutput on
set verify off

create or replace procedure calcul (v_number1 IN number, v_number2 IN number) IS
Begin

   dbms_output.put_line ('Total of two numbers: ' || v_number1 + v_number2);
   dbms_output.put_line ('Difference of two numbers: ' || v_number1 - v_number2);
   dbms_output.put_line ('Product of two numbers: ' || v_number1 * v_number2);

end;
/
Declare

   v_num1 number;
   v_num2 number;
Begin

   v_num1 := &number1;
   v_num2 := &number2;

   calcul(v_num1,v_num2);   

end;

---

and getting errors in executing it as below: SQL> @testplsql;

Procedure created.

Enter value for number1: 15
Enter value for number2: 5
Declare
*
ERROR at line 1:

ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "SYSTEM.CALCUL", line 4
ORA-06512: at line 8

I tried to fix with to_number() but still cannot:

Declare

   v_num1 number;
   v_num2 number;
Begin

   v_num1 := to_number(&number1);
   v_num2 := to_number(&number2);

   calcul(v_num1,v_num2);   

end;

Where is my mistake in this PL/SQL block?

Thanks in advance for any help

DH Received on Mon Apr 21 2003 - 21:26:24 CDT