merlyn has asked for the wisdom of the Perl Monks concerning the following question:
I have a prepare on a DBD::Oracle database:
But now I understand I have to tell Oracle that the fourth column is a blob. I see that I have to usemy $sth = $dbh->prepare(<<''); INSERT INTO sometable (x, y, z, blobby) VALUES (?, ?, ?, ?) $sth->execute('x', 'y', 'z', $blobdata);
but the examples show only a single value, and not multiple values, so I'm not sure how to sequence both the execute and the (hopefully single) bind_param.$sth->bind_param($field_num, $lob_value, { ora_type => ORA_BLOB });
Help!
-- Randal L. Schwartz, Perl hacker
Be sure to read my standard disclaimer if this is a reply.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Help with DBD::Oracle Blobs
by RazorbladeBidet (Friar) on Mar 04, 2005 at 21:18 UTC | |
by merlyn (Sage) on Mar 04, 2005 at 21:38 UTC | |
by jbrugger (Parson) on Mar 04, 2005 at 21:53 UTC | |
Re: Help with DBD::Oracle Blobs
by jbrugger (Parson) on Mar 04, 2005 at 21:18 UTC | |
Re: Help with DBD::Oracle Blobs
by fizbin (Chaplain) on Mar 05, 2005 at 16:33 UTC | |
Re: Help with DBD::Oracle Blobs
by Thilosophy (Curate) on Mar 05, 2005 at 13:31 UTC |
Back to
Seekers of Perl Wisdom