Re: Oracle CLOB

From: The Magnet <art_at_unsu.com>
Date: Wed, 22 Sep 2010 11:56:23 -0700 (PDT)
Message-ID: <b31654ec-d4e1-4f07-95e0-971b2322c5ac_at_y3g2000vbm.googlegroups.com>

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? Received on Wed Sep 22 2010 - 13:56:23 CDT