develooper Front page | perl.dbi.users | Postings from March 2008

perl DBI oracle and error ORA 06502

Thread Next
From:
Pompiliu
Date:
March 18, 2008 18:36
Subject:
perl DBI oracle and error ORA 06502
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 Next


Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About