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

Home -> Community -> Usenet -> c.d.o.misc -> 9.0.2 varchar2(32767) acting like varchar2(4000)

9.0.2 varchar2(32767) acting like varchar2(4000)

From: Dave in Roanoke <pmmgpgp_at_gmail.com>
Date: 3 Aug 2006 08:53:56 -0700
Message-ID: <1154620436.700223.191950@m79g2000cwm.googlegroups.com>


I have oracle 9i rls 2.

I am experiencing a size problem using varchar2. (4000 limit?) .

I have ( as shown below) a type with field that I expect to be able to hold 32k of text.

CREATE OR REPLACE TYPE PO_Comment_Detail AS OBJECT (

PO           VARCHAR2(14),
Head_or_Line VARCHAR2(14),
buyer_code   varchar2(6),
POComment    VARCHAR2(32767)

)

I have a procedure that works flawlessly except for populating POComments. It accumilates a good deal of into a varchar2(32767) and trys to put it into POComment. To get data into POComments I have to reduce its size substr(AComment2Write,1,4000) works and
substr(AComment2Write,1,4001) doesn't.

Any thoughts on what is happening or more to the point how I can make it work ?

Thanks
Dave Received on Thu Aug 03 2006 - 10:53:56 CDT

Original text of this message

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