Re: perl and long fields in oracle

I have the same problem. It looks like oracle's ODBC driver is to blame. I can read NOTE fields (up to 32k) in Pervasive.SQL tables from perl but not oracle's long.

Please let me know if you find a fix.

Bernhard Mandl
(b.mandl_at_ping.at)

Rüdiger J. Schulz wrote in message <367571DB.CB4329CF_at_berlin.de>...
>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 Wed Dec 16 1998 - 10:36:47 CST