Re: Oracle CLOB
From: The Magnet <art_at_unsu.com>
Date: Thu, 23 Sep 2010 09:59:36 -0700 (PDT)
Message-ID: <527c0587-30fc-4470-b0e1-c0f30dc3e846_at_c21g2000vba.googlegroups.com>
On Sep 23, 11:36 am, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> The Magnet wrote:
>
> > 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?
>
> Read my lips: Oracle SQL can only handle 4K.
Date: Thu, 23 Sep 2010 09:59:36 -0700 (PDT)
Message-ID: <527c0587-30fc-4470-b0e1-c0f30dc3e846_at_c21g2000vba.googlegroups.com>
On Sep 23, 11:36 am, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> The Magnet wrote:
>
> > 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?
>
> Read my lips: Oracle SQL can only handle 4K.
4k? What is the use of CLOB if it can only handle 4k, make it a VARCHAR2? That makes no sense.
A stored procedure should be able to receive a CLOB and store it in a CLOB column. Heck, think of the articles on CNN and other sites. Do you think they are only 4k? Most images are greater than 4k also. Received on Thu Sep 23 2010 - 11:59:36 CDT