Re: select long type column

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.

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?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 08 1998 - 00:00:00 CDT