Re: INSERT BLOB data though DBI:Proxy

I am not sure for inserts, but for selects I had to set some parameters on Oracle so that it would not truncate data I retrieved from blobs

given a connection called $dbh

$dbh->{LongTruncOk} = 1;
$dbh->{LongReadLen} = 2**14 - 8;
[download]

Then I would do my select after these calls

Comment on Re: INSERT BLOB data though DBI:Proxy Download Code

Replies are listed 'Best First'.
Re^2: INSERT BLOB data though DBI:Proxy by mouser13 (Novice) on Sep 05, 2008 at 15:54 UTC
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]	[reply] [d/l]