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

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