Streaming Binary Data to Oracle DB BLOB
sojiro_at_twcny.rr.com
Date: 02/16/05
- Next message: sojiro_at_twcny.rr.com: "Streaming Binary Data to Oracle DB BLOB"
- Previous message: Stephane Legault: "export to"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 16 Feb 2005 08:05:01 -0800
Hello,
I'm using Perl to insert a binary file into a BLOB field in an Oracle
database. I know it is possible to insert the data into the database by
opening and reading the file into a variable first then inserting it
into the database. My question is can I stream that data from the file
to the database and skip the variable in between? I have tried things
similar to the following but they have not seem to work.
my $FH
open(FH, "binary.file");
$sth->bind_param(1, \$FH, {ora_type => ORA_BLOB});
close(FH);
This yeilds the following error...
Can't bind a reference (SCALAR(0x821c0b8))
I greatly appreciate any suggestions.
- Next message: sojiro_at_twcny.rr.com: "Streaming Binary Data to Oracle DB BLOB"
- Previous message: Stephane Legault: "export to"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
