Re: Oracle CLOB

From: The Magnet <art_at_unsu.com>
Date: Wed, 22 Sep 2010 20:45:58 -0700 (PDT)
Message-ID: <30ae6fc4-0ce3-48de-bf59-8df4343f46d8_at_g21g2000prn.googlegroups.com>



On Sep 22, 3:57 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> The Magnet wrote:
> > On Sep 22, 1:29 pm, "Gerard H. Pille"<g..._at_skynet.be>  wrote:
> >> The Magnet wrote:
> >>> On Sep 21, 12:22 pm, "Gerard H. Pille"<g..._at_skynet.be>    wrote:
> >>>> The Magnet wrote:
> >>>>> Ok, this is probably simple, what I'm lost.  FYI:  We're on 10gR2.
>
> >>>>> I'm trying to update a CLOB column.  The procedure is being called
> >>>>> from PHP.  If the INSERT procedure is called then the object gets
> >>>>> inserted into the table properly:
>
> >>>> How does PHP connect to the database?   OCI8?
>
> >>> Yes, it uses OCI8.  I'm thinking there is a limitation somewhere
> >>> there, but I do not know enough about that.  Are you familiar with
> >>> OCI8?
>
> >> Yes, but I remember trying to store pictures in the database, without succes.
>
> >> In the example here (http://wiki.oracle.com/page/PHP+Oracle+FAQ), the blob is loaded from a file.
>
> >> Don't forget the limits of pure SQL.   Maybe you can only update when p_body<  4k.
>
> >> But you provide only enough information for guess-work.  There's quite a number of places where
> >> things can go wrong.
>
> > That is so strange.  Here is the procedure declaration:
>
> > PROCEDURE update_message_by_message_id (
> >    p_message_id       NUMBER,
> >    p_sec_id           NUMBER,
> >    p_variables        VARCHAR2,
> >    p_name             VARCHAR2,
> >    p_body             CLOB,
> >    p_changed_by       VARCHAR2,
> >    p_status           VARCHAR2) IS
>
> > Thoughts?
>
> The same as before: the update statement can only handle 4K.
>
> Have a look at the manuals on how to use dbms_lob package inside your procedure.

Well, sorry for being like this. But a CLOB can handle 4GB, right? So, I would think the problem is between PHP and Oracle, maybe something in the communication? Received on Wed Sep 22 2010 - 22:45:58 CDT

Original text of this message