Home » Developer & Programmer » Forms » desformat and web.show_document (forms
desformat and web.show_document [message #402138] Thu, 07 May 2009 16:34 Go to next message
Messages: 92
Registered: September 2008

I'm trying to write a file to another server using web.show_document to run a report from a form.

I'm using web.show_document because our reports run on the server that I want this file.

I want the file to be a text file.

I have no problem doing this. However, I have to set desformat='delimited'.

When desformat='delimited', the lines in the report appear all in one line.

Is there a way to go to a new line for the fields in the report?

For example, I have 10 fields on the report. I want each field to appear under the previous field. I have it set up this way in the report.

However, for desformat='delimited', the text appears as follows:

text for field1 text for field2 text for field3 etc.

I want it to appear as

text for field1
text for field2
text for field3

Any suggestions?
Re: desformat and web.show_document [message #402703 is a reply to message #402138] Tue, 12 May 2009 02:28 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you considered using 'utl_file'?

Previous Topic: double click
Next Topic: Migration forms 4.5 to 10gR2
Goto Forum:

Current Time: Sat Jan 21 17:49:20 CST 2017

Total time taken to generate the page: 0.32591 seconds