Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03113 error Please HELP!!
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