| 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() ;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
