On Tue, 2008-03-18 at 14:06 -0700, Pompiliu wrote:
...
> $dbh->func(10, 'dbms_output_enable');
> right after connect.
> The problem is that I am getting only part of the
> result and the error I am getting is ORA 06502.
ORA-6502 is often the result of size mismatch between variables and
> -Original Message-
> From: John Scoles [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 20, 2008 5:27 AM
> Cc: Pompiliu; dbi-users@perl.org
> Subject: Re: perl DBI oracle and error ORA 06502
>
> You might want to set the DB handles "LongReadLen" attribute
You might want to set the DB handles "LongReadLen" attribute to a higher
values say 100 meg like this
dbh->{LongReadLen} = 100*1024*1024
and then give it a try,
That might work for you.
Cheers John Scoles
John Scoles wrote:
It could be in perl but if this is the case I would need the exact
It could be in perl but if this is the case I would need the exact
procedure, schema, some data and the exact perl code that calls it.
However to start please set the dbh->debug(6) before you call your code
and send me the results. There might be
a var that Perl is croaking on and this is one w
Ah yes the APPLE][ error for those of us who are old enough to remember
those things
here is what the error code means
*ORA-06502:*PL/SQL: numeric or value error /string/
*Cause:* An arithmetic, numeric, string, conversion, or constraint
error occurred. For example, this error occurs if a
Hi,
I am running DBI and Oracle DB; I am executing a
package and using
$dbh->func('dbms_output_get')
as in
my $row;
while (($row = $dbh->func('dbms_output_get')))
{
print "$row\n";
}
if ($sth->err) {
print STDERR "ERROR: $DBI::err
