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
ptik
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

#!/usr/bin/perl
use DBI;
use DBD::Oracle qw(:ora_types);
print "Content-type:text/htmlnn";
$ENV{ORACLE_HOME} = '/oracle/ora92';
$ENV{TWO_TASK} = 'iais';
$ENV{NLS_LANG}='RUSSIAN_CIS.CL8MSWIN1251';
$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: php4 connectivity with oracle
Goto Forum:
  


Current Time: Thu Mar 28 07:31:15 CDT 2024