PL/SQL help needed (newbie)

I have the procedure

procedure myproc(amt OUT varchar2) AS

BEGIN
        select to_char(233.3,'9,999') into amt from dual; END myproc;

when I run the proc I get a 'numeric or value' error. It appears that I cannot insert the value returned by to_char into the variable amt.

As far as I am aware amt is of the correct datatype - varchar2. What am I doing wrong?

Thanks Received on Wed May 26 1999 - 05:16:55 CDT