Oracle 11g save clob to file

February 03, - pm UTC. I mean, the database just stores whatever you put in there. Hi, Tom, Does this "32k in length that do not contain a newline, you will get that error" suitable for reading a file? Another words, what about the file need to be read contains a line of 32K length without new line, is it a problem?

January 09, - am UTC. March 24, - am UTC. Sir , is that mean no way to make the web client able to get that text file?! March 24, - pm UTC. Whats wrong? How can I skip empty lines? If user has manually created the file, it -- will have DOS newlines. March 17, - am UTC. I have stared at this for a long time but nothing is jumping out! A reader, March 17, - am UTC. This one doesnt! It goes in a infinite loop. I put a autonomous transaction in my proc to log to a table and saw it.

I will fix this. December 22, - am UTC. Why I must flush after every put? Zilvinas, April 24, - am UTC. Read SELF.

Is it a bug or is it a feature? April 27, - pm UTC. If you do not hit an end of line marker before that - you will get an error. Nihal, May 07, - pm UTC. Whats the way around it? I am using version May 11, - pm UTC. May 13, - am UTC. Plenty of character set issues in your future should you do that.

Also, did you actually try it with more than 32k? There is an implicit conversion of the clob to varchar2. I'll stick with the original answer - java stored procedure or external client program. Multibyte character boundaries are ignored. The data is not modified in any way, it is only changed to data type RAW.

I expect the file to be written , independent from the charset and until now I had no problems. Where do you expect problems?

Regards Marcus. Dumping CLOB fields into files? Ask Question. Asked 10 years, 4 months ago. Active 1 year, 8 months ago. Viewed 36k times. Add a comment. Active Oldest Votes. LukStorms LukStorms I've added a procedure clob2file to it that can replace it. It's useful to use inside the loop if you want to read the file while it is still open. But if you just want to read the file after it's written, outside the loop is good enough.

MatthewMoisen It's as you suspect. There was a problem with dumping the file, so why care about shaking that last spunk from the filebuffer? Show 4 more comments. Community Bot 1 1 1 silver badge. Justin Cave Justin Cave k 22 22 gold badges silver badges bronze badges.

You'd be looking at doing something like querying the table and using the data to dynamically generate one SQL Plus script per file that you wanted to generate and then dynamically calling those scripts. If you do need to generate files on the client file system, I'd generally prefer to use something other than SQL Plus.

I'd tend to write a small Java utility that ran on the client and exported the data rather than trying to put too much logic in SQL Plus scripts. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.

Dumping CLOB fields into files? Ask Question. Asked 10 years, 4 months ago. Active 1 year, 8 months ago. Viewed 36k times. Add a comment. Active Oldest Votes. LukStorms LukStorms I've added a procedure clob2file to it that can replace it.