ociuldr is a free OCI utility to extract table rows from Oracle database to flat file. In previous release, when extracting long type column, it will read maximum 32767 bytes, but now I have add a new command line option "long=maxbytes" to control the maximum length to extract. This could save some client memory when extract short long column.
The new default maximum value is 4000, for example:
$ociuldr user=anysql/anysql@prod sql=test.sql
4100 bytes allocated for column COL1 (1)
400100 bytes allocated for column COL2 (2)
Test the new command line option, you will found the difference.
$ociuldr user=anysql/anysql@prod sql=test.sql long=8000
4100 bytes allocated for column COL1 (1)
800100 bytes allocated for column COL2 (2)
New binary have been uploaded, you could download or update it.