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

Dave in Roanoke wrote:
> Daniel
>
> Thank again for extending yourself.
>
> I regert the poorly submitted request. I expect that the
> 4000 would be something that was an acknowledged
> limitation.
>
> I agre with what you have said so far, but did you noticed
> my attempted clarification in my 2nd post "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 ".
> Thru trial and error I pined down the 4000 - 4001
> breakpoint.
>
> Any thought on what may be happening ?
>
> My thanks again
> Dave

VARCHAR2 in a table is limited to 4K.
A VARCHAR2 variable is 32K.

What is it you are actually trying to do?

-- 
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