Re: UTL_FILE.put 1024 bytes limitation under Oracle 7

Hi

You could try parsing your text in PL/SQL and cropping the lines at 1023 bytes and adding a "control character" i.e "|" at the end of the line (to signify it isn't really the end of the line) and post process the output and replace the "|" by removing it and joining the line with a shell script or sed or perl or whatever?

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.