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 an attempt is made to
assign the value NULL to a variable declared NOT NULL, or if an attempt
is made to assign an integer larger than 99 to a variable declared
NUMBER(2).
*Action:* Change the data, how it is manipulated, or how it is declared
so that values do not violate constraints.
So I would first have a look at your data looks like there is something
in the PSQL of the packge dbms_output_get that is giving you the
error. In this case DBI and DBD::Oracle are simply working as they
should returning an error message from the database.
cheers
John Scoles
Pompiliu wrote:
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::errstr";
}
to pull the output; I did set
$dbh->func(1000000000, '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.
Everything works fine up to here. How can I fix this?
Please email.
Thanks. P
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
