Front page | perl.dbi.users |
Postings from March 2008
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
>
Thread Previous