Re: select long type column

A copy of this was sent to bonanos_at_yahoo.com (if that email address didn't require changing) On Tue, 08 Sep 1998 09:18:44 GMT, you wrote:

>Hi Thomas
>
>
>> That piecewise fetches a long with 4k chunks. You send it a query that select
 a
>> single row and a single column (a long). It prints it out on the web in this
>> example (the htp.p call) but you can do whatever you want with it...
>
>What is maximum length of a long chunk you can select with an ordinary select
>statement in oracle 8.
>

it is still 32k. pl/sql has a limit on variable lengths of 32k.

>I am select plain text from a long column, and it is working fine, I do not
>expect the long's to be very ling initialy.
>
>This is what I am doing:
>
>select article,a_date into e_article,e_date
> from sotiri.bus_news_articles.
>....
>htp.p(e_article);
>
>Is it wrong?

not as long as the e_article column does not exceed 32k. If it does, you'll need the dbms_sql example I posted in a prior post on this thread.

>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.