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 -> Re: 9.0.2 varchar2(32767) acting like varchar2(4000)

Re: 9.0.2 varchar2(32767) acting like varchar2(4000)

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 03 Aug 2006 11:02:10 -0700
Message-ID: <1154628131.921234@bubbleator.drizzle.com>


Dave in Roanoke wrote:
> One thing I left out.
> I compiles w/o error.
> I can test without any problem.
> My problem is that when I look at the refcursor
> (see lines 78 and 79 ) I get the following if I
> don't truncate the length
> ORA-00910;specified length too long for its datatype
>

CREATE OR REPLACE TYPE PO_Comment_Detail AS OBJECT (

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

/

DECLARE
  Type PO_Comments IS TABLE OF PO_Comment_Detail;   Comments2Return PO_Comments:= PO_Comments(); BEGIN
   comments2return.extend(1);
   comments2return(comments2return.last) := po_comment_detail('A', 'B', 'C', RPAD('X', 32766, 'Z'));
END;
/

And the issue is? ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Aug 03 2006 - 13:02:10 CDT

Original text of this message

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