Hi,
Can you tell me why
"Insert into Foo values (?, EMPTY_BLOB()) returning data into ?"
causes a segmentation fault.
Where Foo is create table Foo (id integer, data blob);
The section of the code that runs this sql statement is
$stmt = "INSERT INTO Foo VALUES (?, EMPTY_BLOB()) returning the_file into
?";
$sth = $dbh->prepare($stmt);
$sth->bind_param(1, $id);
$sth->bind_param_inout(2, \$loc, 1000, {ora_type => ORA_BLOB});
$sth->execute or die $dbh->errstr;
My perl/oracle/os/machine config is as follows:
Perl: 5.8.3
Oracle: 9i2
OS: GNU/Linux
Kernel: 2.4.18-14
machine: i686
processor: i686
hardware platform: i386
Any hints appreciated..
Much thanks
Raj