perl and long fields in oracle

how to read a long-field with perl ?

Table: create table test ( id number(10), test long); Insert into test (id, test) values (1, 'xxxxxx ....'); -- -> more than 2000 ascii-characters

perl:
...
$dbh = DBI->connect(....);
$query = "Select test from test";
$sh = $dbh->prepare($query);
$sh->execute;
$row = $sh->fetchrow;

print "$row\n";
$sh->finish;
$dbh->disconnect();

...

but nothing in $row !!!! No output!
what´s wrong ???

R.J. Schulz Received on Mon Dec 14 1998 - 14:15:23 CST