UTL_FILE.put_line limitation under Oracle 7

Hi all,

I have a problem to put lines with about 3000 characters in my output
file using UTL_FILE.put package.

I'm using Oracle 7 !! So I can not specify the line size in
UTL_FILE.FOPEN function. ==> Compilation errors

How can I write a line of 3000 characters even though I am using
Oracle 7 ?

thanks a lot.

You can't if you prefer to stay in the Stone Age. Do you still have
vinyl records operated by a bird?

Sybrand Bakker
Senior Oracle DBA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 8th February 00:09 chriffe External User Posts: 1	UTL_FILE.put_line limitation under Oracle 7 Hi all, I have a problem to put lines with about 3000 characters in my output file using UTL_FILE.put package. I'm using Oracle 7 !! So I can not specify the line size in UTL_FILE.FOPEN function. ==> Compilation errors How can I write a line of 3000 characters even though I am using Oracle 7 ? thanks a lot.

2 8th February 00:09 External User Posts: 1	UTL_FILE.put_line limitation under Oracle 7 You can't if you prefer to stay in the Stone Age. Do you still have vinyl records operated by a bird? Sybrand Bakker Senior Oracle DBA