Set columnwidth on recordset??

[DugsDMan]

I have a co-worker who is having problems returning a loooong string from an Oracle function. The results are being passed back in a recordset containing one column, but many records. It's truncating the results in each column at 1000 characters. Is there a way to increase this variable value? Possibly altering a session variable or something??

Thanks!

 

[DugsDMan]

Never mind...the limit is in the GUI tools we're using to analyze the data. When we spool it to a file, it's fine.

 

[SantaMufasa]

Dug,

I see that you have your problem solved for now, but for future reference/consideration, if you (or your colleague) use CLOB instead of LONG (in either table or function definitions), you lose all the downsides/limitations of LONGs and you gain all the advantages of VARCHAR2s: You can treat a CLOB in precisely the same way you would a VARCHAR2, but you can store up to 2,147,483,647 characters.

Mufasa
(aka Dave of Sandy, Utah, USA @ 20:05 (08Jul04) UTC (aka "GMT" and "Zulu"), 13:05 (08Jul04) Mountain Time)