Home » Open Source » Programming Interfaces » Can't insert data to blob-field using Perl
Can't insert data to blob-field using Perl [message #11345] Sun, 21 March 2004 22:55
Messages: 1
Registered: March 2004
Junior Member
I tried to insert data to blob-field using Perl
log-file didn't show any error, TOAD said that field is not empty.
But Perl didn't read this data and PHP had a error "Call to a member function on a non-object".

I reckon that a problem with DBD but I can't find out it.
May be you could check this simple script by your own server?
If it will be work, I'll be sure in my version. Or may be you'll find my error in script

use DBI;
use DBD::Oracle qw(:ora_types);
print "Content-type:text/htmlnn";
$ENV{ORACLE_HOME} = '/oracle/ora92';
$ENV{TWO_TASK} = 'iais';
$dbh = DBI->connect('dbi:Oracle:', 'dbname', 'passwd');
$dbh->{LongReadLen} = 100000;

$rs = $dbh->prepare("update table_name set field_name=? where id=329");
$rs->bind_param(1, "blablabla", { ora_type => ORA_BLOB });
$rs->execute() ;
Previous Topic: How to handle Clobs in Perl
Next Topic: NUMROWS problem (in PHP)
Goto Forum:

Current Time: Tue Aug 22 23:31:23 CDT 2017

Total time taken to generate the page: 0.01652 seconds