Home » Developer & Programmer » Forms » Create text file
Create text file [message #255842] Thu, 02 August 2007 01:15 Go to next message
oracle06
Messages: 36
Registered: December 2005
Member
Hello All,

I have a report in which almost every field is displaying data
through formula column(not database item),so I have created a
new table and inserted calculated amount using insert into
statement through report only.Now I have to create text
file of data(new table data)using TEXT_IO....
How to use TEXT_IO for getting text file for data of the new
table.

Please guide.

Thanks.

[Updated on: Thu, 02 August 2007 04:39]

Report message to a moderator

Re: Using TEXT_IO ! [message #255878 is a reply to message #255842] Thu, 02 August 2007 04:36 Go to previous messageGo to next message
oracle06
Messages: 36
Registered: December 2005
Member
Hello,

I am Simplifying my query,please tell how to create text file
for data which is present in a table.I have inserted records in a table using report 6i.after execution of report data is inserted in the table and I want this data in a text file.


Please tell me as soon as possible.


Thanks.

Re: Using TEXT_IO ! [message #255895 is a reply to message #255878] Thu, 02 August 2007 05:14 Go to previous messageGo to next message
linlasj
Messages: 98
Registered: August 2005
Location: Linköping
Member
Hi,
Have a look at the UTL_FILE functionality. Be sure to open up the directories to write to in DB parameter UTL_FILE_DIRECTORY.


Best Regards,
Lars
Re: Using TEXT_IO ! [message #255909 is a reply to message #255895] Thu, 02 August 2007 05:49 Go to previous messageGo to next message
oracle06
Messages: 36
Registered: December 2005
Member
Hi,

can you explain it how to use this utl file through forms or reports.

please tell how to do it.

Thanks.

Re: Using TEXT_IO ! [message #255988 is a reply to message #255909] Thu, 02 August 2007 11:52 Go to previous message
linlasj
Messages: 98
Registered: August 2005
Location: Linköping
Member
Hi,
I typed UTL_FILE to http://www.google.se (since I am living in Sweden) and these links came up, start there:

http://www.adp-gmbh.ch/ora/plsql/utl_file.html

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_file.htm#ARPLS069

The second one is the one you should probably start, since that is, as I can see thru a quick browse, the documentation from Oracle on UTL_FILE.

Do not hesitate to ask questions after reading the documentation. I will be happy to answer, and remember, note that the UTL_FILE_DIRECTORY parameter has to be set to a directory where you write files.

Btw, I should not use it thru Oracle Reports.


Best Regards,
Lars
Previous Topic: table of records index
Next Topic: Forms 6i and Oracle 10g R2
Goto Forum:
  


Current Time: Fri Dec 09 15:44:56 CST 2016

Total time taken to generate the page: 0.22785 seconds