Correct me if I am wrong, but I don't believe you can. I believe that's an
Oracle (not DBD::Oracle) limitation.
You will probably have to do an insert and an update.
Ilya
> -----Original Message-----
> From: Christian Gruber [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 11, 2001 7:50 AM
> To: [EMAIL PROTECTED]
> Subject: Oracle BLOB problem
>
>
> Hello!
>
> I'm using DBI 1.18, DBD::Oracle 1.07 and Perl 5.005_05. My Software is
> running on Linux and I am working with Oracle 8.1.7.
>
> Here the problem: I can't perform an insert statement that has more
> than one BLOB. I use bind_param(...., {ora_type=>ORA_BLOB}) to bind
> the parameters, which works fine for one single BLOB. But when the
> insert statement contains 2 BLOBs, I get the following error:
>
> DBD::Oracle::st execute failed: (DBD ERROR: Need bind_param(...,
> { ora_field=>... }) attribute to identify table LOB field names)
>
> I have included a test script that reproduces the problem on my
> machine.
>
> Does anybody have a clue?
>
> Thanks in advance
>
> Christian
>
>
>
>
