Oracle7 LONG vs. PL/SQL LONG

[Quoted] [Quoted] Hello all...

[Quoted] I'm having some trouble getting at the data in a LONG column.

[Quoted] I understand that the PL/SQL LONG is only 32760 characters long, while [Quoted] the ORACLE7 LONG is 2 GB or so. Nonetheless, I have to generate a web [Quoted] page with the contents of my LONG column in it. How do I get at it? Do I [Quoted] have to resort to another language, or is there some way I can persuade PL/SQL to deal with it?

[Quoted] [Quoted] I'm using an explicit cursor in a FOR loop. I use the cursor output as [Quoted] input to htp.tableData calls to generate the web page. It works fine as [Quoted] long as the data in the column is <= 32760. If I push it to 32761, I get a value_error exception.

[Quoted] [Quoted] I will use perl (DBI) for this if I have to, but it will be much more [Quoted] painful if I do. Does anyone know of a way to get around this limitation [Quoted] in PL/SQL??

Thanks much!

Leslie

-- 
[Quoted] Leslie Dreyer Kalra
Techies, Inc.
lbd_at_techiesinc.com