ORA-06502 when using to_char function

I have a stored procedure in Oracle with a varchar2 out parameter.

CREATE OR REPLACE procedure
a_proc ( a_string out varchar2 )

In the body of the stored proc I've declared a variable v_num number(9,3) which is initialized by a select statement

select some_col into v_num from some_table;

Now, I want to convert v_num into a string and assigned it to the out parameter.

select to_char(v_num,') into a_string from dual;

The stored proc is valid when I compile it, but I get this error when I run it:

ORA-06502, "PL/SQL: numeric or value error"

Can someone tell me what I'm doing wrong ?

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 17 2000 - 00:00:00 CDT