Re: PL/SQL help needed (newbie)

I'm calling it from a DBI perl routine:

my %sth = $dbh->prepare(q{

    BEGIN
       myproc(totalamt => :totalamt);
    END;
 });

$sth->bind_param_inout(":totalamt",\$totalamt,10);

The problem occurs within the proc when it sets the OUT variable to a character string with a length greater than 1. Of couse, I can't declare the OUT variable to be a varchar2(n), only a varchar2.

So how does the OUT variable accept a value with more than 1 character. I'm going round in circles and am very confused

Help appreciated

The problem is happening within the stored proc. The v_amt variable is

Mark Gumbs wrote in message <374bcf5c.0_at_145.227.194.253>...
>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 - 06:49:19 CDT