perlquestion
merlyn
I have a prepare on a [cpan://DBD::Oracle] database:
<code>
my $sth = $dbh->prepare(<<'');
INSERT INTO sometable (x, y, z, blobby) VALUES (?, ?, ?, ?)
$sth->execute('x', 'y', 'z', $blobdata);
</code>
But now I understand I have to tell Oracle that the fourth column
is a blob. I see that I have to use
<code>
$sth->bind_param($field_num, $lob_value, { ora_type => ORA_BLOB });
</code>
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.
<p>
Help!
<!-- Node text goes above. Div tags should contain sig only -->
<div class="pmsig"><div class="pmsig-9073">
<p>-- [http://www.stonehenge.com/merlyn/|Randal L. Schwartz, Perl hacker]
<br>
Be sure to read [id://205373|my standard disclaimer] if this is a reply.</p>
</div></div>