OraFAQ Forum: Forms » Create text file

Home » Developer & Programmer » Forms » Create text file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create text file [message #255842]

Thu, 02 August 2007 01:15

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

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.

Report message to a moderator

Re: Using TEXT_IO ! [message #255895 is a reply to message #255878]

Thu, 02 August 2007 05:14

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

Report message to a moderator

Re: Using TEXT_IO ! [message #255909 is a reply to message #255895]

Thu, 02 August 2007 05:49

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.

Report message to a moderator

Re: Using TEXT_IO ! [message #255988 is a reply to message #255909]

Thu, 02 August 2007 11:52

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

Report message to a moderator

Previous Topic:	table of records index
Next Topic:	Forms 6i and Oracle 10g R2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 18:29:55 CST 2025