Re: PL/SQL help needed (newbie)

I assume you are calling the procedure from somewhere else

e.g

declare

     v_amt varchar2(5);
begin

     myproc(v_amt);
end;

If your declaration of v_amt is not big enough (e.g varchar2(2) instead of varchar2(5) ), this will cause a numeric or value error.

Mark

Paul Wiles wrote in message <374bc9ff_at_newsread3.dircon.co.uk>...
>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:48:55 CDT