Re: Long columns obsolete

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 06 Dec 2003 22:57:26 -0800
Message-ID: <1070780277.706750@yasure>

Burt Peltier wrote:

> Hmmm .. my mistake.
>
> I just restested and it does appear ok to even to pass the 32767 characters
> via a varchar2 column in the parameter list between PlSql procedures.
>
> We are using 8.1.7.4.0 on Sun Solaris 8 for the server and 8.1.7.0.0 for the
> client .
>
> Note: There is a very descriptive message ( PLS-00215 ) if you try to
> declare a varchar2 variable at 32K (or 32787). It specifically mentions
> 32767 as the max.
>
> --
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1070759060.454365_at_yasure...
>

>>Burt Peltier wrote:
>>
>>
>>>Ok... I may be wrong, but I just recently did a lot of testing of the

>
> limits
>

>>>of varchar2 and could have sworn that when passing an argument with 4001
>>>characters for a varchar2, I got some kind of error in the call... the

>
> PlSql
>

>>>code was never even envoked I think.
>>>
>>>I was looking for a way to pass more than 4000 characters .. not more

>
> than
>

>>>32K .
>>>
>>>So, are you saying it is ok to store in memory, but just cannot pass it
>>>around (between PlSql units) or store in a table(obviously) ?
>>>
>>
>>4K in columns, 32K for the variables in 8i and above. What version do
>>you have.
>>
>>-- 
>>Daniel Morgan
>>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
>>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
>>damorgan_at_x.washington.edu
>>(replace 'x' with a 'u' to reply)

You can also pass in CLOBs up to 4GB and work with them. But you must use the DBMS_SQL package's PARSE and SQL_TABLE to accomplish it.

And example of how to do this with DBMS_SQL can be found at the bottom of the page at: http://www.psoug.org/reference/dbms_sql.html The site is still under construction but this demo is complete.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sun Dec 07 2003 - 00:57:26 CST