Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10g clob

Re: 10g clob

From: rjamya <rjamya_at_gmail.com>
Date: Fri, 21 Oct 2005 18:32:28 -0400
Message-ID: <9177895d0510211532l3c7200c9m3a1e828e782f04ce@mail.gmail.com>


let's start with error messages ...

Raj

On 10/21/05, Joan Hsieh <joan.hsieh_at_tufts.edu> wrote:
>
> Hi list,
>
> ORACLE 10.1.0.4 <http://10.1.0.4>
> solaris 9
> application : sunone fatwire
>
> The following message is from our java developer who had problem with
> clob or varchar(2000), I would like to know if someone happen to know
> these kind of problem and give us a guide to solve the problem.
>
> Thanks,
>
> Joan
>
> I ran 2 tests on the Development Box:
>
> one with Content Server property set to Oracle VARCHAR(2000) and one
> with CS property set to Oracle CLOB. I can save an asset with small
> amount of text, but when I try to input a page worth of text, it throws
> me the same error in CS in either of the test cases. I have looked at
> the app server logs and they do not have anything recorded at all.
>
> I have indicated the exact time CS return me an error so that it can
> help you to find the Oracle error message (if it is recorded).
>
>
> *******************************************************************************
>
>
> Time: 10:52
> CS datatype is set to Oracle VARCHAR(2000): cc.bigtext=VARCHAR(2000)
>
> CS error message on fwdevweb01.tccs.tufts.edu<http://fwdevweb01.tccs.tufts.edu>(Dev Box):
>
> Cannot save asset.
>
> This attempt to save the DCA Image has failed.
>
> Possible causes:
> (1) Another DCA Image already exists with the same information in a
> field that must be unique.
> (2) The text you have entered in one or more fields in the form does not
> fit in the corresponding database field.
> (3) The text you have entered in a field does not match the format
> required by the corresponding database field.
>
> Please use the browser's Back button to return to the Edit form, make
> the necessary changes, and retry this operation. If the problem
> persists, please contact your system administrator.
>
>
>
> *******************************************************************************
>
> Time: 11:10a.m.
> CS datatype is set to Oracle CLOB: cc.bigtext=CLOB
>
> same CS error message on fwdevweb01.tccs.tufts.edu<http://fwdevweb01.tccs.tufts.edu>(Dev Box):
>
> Cannot save asset.
>
> This attempt to save the DCA Image has failed.
>
> Possible causes:
> (1) Another DCA Image already exists with the same information in a
> field that must be unique.
> (2) The text you have entered in one or more fields in the form does not
> fit in the corresponding database field.
> (3) The text you have entered in a field does not match the format
> required by the corresponding database field.
>
> Please use the browser's Back button to return to the Edit form, make
> the necessary changes, and retry this operation. If the problem
> persists, please contact your system administrator.
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 21 2005 - 17:34:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US