I tried your code tmaly didn't help or cause any problems I think. The problem is does DBI::Proxy support the passing of oracle types? I just added the two lines after the conn statment.

$conn = DBI->connect($dsn, $pguser, $pgpassword,{LongReadLen=>15000000
+,AutoCommi
t=>1,RaiseError=>1,PrintError=>1});
$conn->{LongTruncOk} = 1;
$conn->{LongReadLen} =15000000;
[download]