Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03113 error Please HELP!!

Re: ORA-03113 error Please HELP!!

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Sun, 31 Aug 2003 16:45:08 +0100
Message-ID: <ts54lv03u7pgq96soi61d4kq4l5fpl81bn@4ax.com>


On Sun, 31 Aug 2003 08:07:28 -0700, Daniel Morgan <damorgan_at_exxesolutions.com> wrote:

>To insert a BLOB using PL/SQL requires inserting an EMPTY_BLOB(), getting
>the length of the BLOB to be inserted, and updating the record with the
>BLOB value.
>
>While I don't write DBD and must confess a great deal of ignorance it is
>readily apparent that the aforementioned steps did not take place.
>Whether they are necessary is that part I can't say for sure.

 FYI - DBD::Oracle actually does do this behind the scenes; provided you bind correctly as a LOB datatype.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Received on Sun Aug 31 2003 - 10:45:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US