Home » Developer & Programmer » Forms » How to save file on local machine (Forms 6i)
How to save file on local machine [message #455102] Mon, 10 May 2010 03:14 Go to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
Hi,

I have a requirement to :
1) at the click of button, some data will be written to XML file and after writting to file, it should get saved to some location on local machine(c:\temp), without asking user, where to save.

How to do this in oracle form?

Also is it possible to read file from local machine?

Report message to a moderator

Re: How to save file on local machine [message #455174 is a reply to message #455102] Mon, 10 May 2010 10:14 Go to previous messageGo to next message
gregor
Messages: 86
Registered: March 2010
Location: Germany
Member
Hi,

if you are using WEB_FORMS
- use the WEBUTIL-Package ( Install it before)
Search-Words:
myfile:= client_text_io.fopen/.. put_line/.. fclose

if you FORMS are running in Client-Server Mode
- use: text_io.fopen/.. put_line/.. fclose

Report message to a moderator

Re: How to save file on local machine [message #455277 is a reply to message #455174] Mon, 10 May 2010 23:27 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You can use 'webutil' / 'd2kwutil' to get the name of the 'temp' directory and save to it.

David

Report message to a moderator

Re: How to save file on local machine [message #455294 is a reply to message #455174] Tue, 11 May 2010 00:25 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
gregor and David,
Thanks to both of you.

In short I will have to use WebUTIL. I am working on Oracle apps E-buisiness suite 11i, which uses 9i DB. Its a 3-tier architecture.

Can I use webutil there? specially with forms 6i. Some people says we can use webutil with forms 6i..

If you think I can use webutil to save file to particular location on local machine, then can you please share approximate code for that...

Report message to a moderator

Re: How to save file on local machine [message #455299 is a reply to message #455294] Tue, 11 May 2010 00:48 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Forms 6i uses 'd2kwutil'. For 'text_io' and 'utl_file' examples go to "Oracle® Database, PL/SQL Packages and Types Reference, 10g Release 2 (10.2), B14258-01" by googling "B14258-01".

David

Report message to a moderator

Re: How to save file on local machine [message #455343 is a reply to message #455102] Tue, 11 May 2010 04:49 Go to previous messageGo to next message
gregor
Messages: 86
Registered: March 2010
Location: Germany
Member
attached an example using "text_io"
replace all "text_io"-calls with "CLIENT_text_io".
( don't forget to attach webutil.pll, before compile)
  • Attachment: P_write.txt
    (Size: 1.88KB, Downloaded 2483 times)

Report message to a moderator

Re: How to save file on local machine [message #455345 is a reply to message #455343] Tue, 11 May 2010 04:52 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
Ok. Thanks to all. I will try this and let you know.

Report message to a moderator

Re: How to save file on local machine [message #456167 is a reply to message #455343] Sat, 15 May 2010 07:40 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
Gentlemen, I couldn't try packages told by you.
I am working on oracle apps EBS and for security reasons it doesn't allow to store and read file on local machine. I asked client to store files on server and I am reading and storing using UTL_FILE.

Anyway, Thanks for you help.

Report message to a moderator

Re: How to save file on local machine [message #609238 is a reply to message #455102] Tue, 04 March 2014 05:49 Go to previous messageGo to next message
randriana
Messages: 18
Registered: September 2010
Junior Member
Hi every body,
Is it possible to save the report, pdf format, locally without using webutil package.
Another problem, i'd like to use webutil package but my version is 10g 10.1.2.0.2, i didn't have metalink account to upgrade it, indeed if i'd like to read some excel format and to store it into my table.
Thanks.

Report message to a moderator

Re: How to save file on local machine [message #609247 is a reply to message #609238] Tue, 04 March 2014 08:21 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
I used Webutil in 10.1.2.0.2 and I am pretty sure I used it in 9i Forms too.

Report message to a moderator

Re: How to save file on local machine [message #610570 is a reply to message #609247] Fri, 21 March 2014 06:52 Go to previous messageGo to next message
randriana
Messages: 18
Registered: September 2010
Junior Member
Hi,
i have attached the form and the version of my form that i tested, it doesn't work on my forms. The test_webutil work fine on my forms.
Thanks for your help

Report message to a moderator

Re: How to save file on local machine [message #610571 is a reply to message #610570] Fri, 21 March 2014 06:53 Go to previous message
randriana
Messages: 18
Registered: September 2010
Junior Member
This is the version of my forms 10g

Report message to a moderator

Previous Topic: FRM-40512: ORACLE error: unable to issue SAVEPOINT command
Next Topic: [REQ] Oracle Developer 6.0 for Win 8.1 x32 x64 ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 11:07:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.