Re: Oracle CLOB

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Wed, 22 Sep 2010 22:57:54 +0200
Message-ID: <4c9a6dd0$0$14248$ba620e4c_at_news.skynet.be>

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. Received on Wed Sep 22 2010 - 15:57:54 CDT