OraFAQ Forum: Forms » Burning a file to CD from Oracle Forms 9i

Home » Developer & Programmer » Forms » Burning a file to CD from Oracle Forms 9i (Oracle Forms 9i)

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

Burning a file to CD from Oracle Forms 9i [message #472693]

Mon, 23 August 2010 05:11

gtforms
Messages: 3
Registered: August 2010

Junior Member

Hello Everyone,

I am working in Oracle Forms 9i, and I have a requirement to copy or burn a file from hard-disk to CD. This should be automatically done at the press of a button in Oracle Forms.

I have already tried using the following statement:

out_Item := TEXT_IO.FOPEN('F:\file3.csv', 'w');

where F: drive represents the CD drive. It threw an ORA-302000 error. Can anybody please suggest how we can achieve burning a file from hard-disk to CD through Oracle Forms. Please, Urgent!! Thanks...

Report message to a moderator

Re: Burning a file to CD from Oracle Forms 9i [message #472694 is a reply to message #472693]

Mon, 23 August 2010 05:20

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

I very much doubt it can be done directly.
Probably you would need to use host to call a seperate program on the PC to write the file to the CD for you.
text_io is certainly not going to be able to do it.

Report message to a moderator

Re: Burning a file to CD from Oracle Forms 9i [message #472697 is a reply to message #472694]

Mon, 23 August 2010 05:47

gtforms
Messages: 3
Registered: August 2010

Junior Member

Thanks cookiemonster for your quick reply. Can we run a batch file from Oracle Forms? If so, can we script the batch file to run a command line CD burning software and write the file to CD? Any suggestions and other ideas will be much appreciated. Thanks.

Report message to a moderator

Re: Burning a file to CD from Oracle Forms 9i [message #472698 is a reply to message #472697]

Mon, 23 August 2010 05:50

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

You can run anything you can run from a windows command line using the host built-in in forms.

Report message to a moderator

Re: Burning a file to CD from Oracle Forms 9i [message #472699 is a reply to message #472698]

Mon, 23 August 2010 05:58

gtforms
Messages: 3
Registered: August 2010

Junior Member

Do you have any examples of the host command? Does the host command work for files which are on the local PC?

Report message to a moderator

Re: Burning a file to CD from Oracle Forms 9i [message #472701 is a reply to message #472699]

Mon, 23 August 2010 06:05

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Form builder help has examples, as it does for every built-in.

It'll work on whichever machine the form is actually running on - so either the local machine, or the web-server if you are using one.

Report message to a moderator

Re: Burning a file to CD from Oracle Forms 9i [message #472703 is a reply to message #472699]

Mon, 23 August 2010 06:22

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member


Host('C:\Program Files\Microsoft Office\OFFICE12\EXCEL.EXE');

Report message to a moderator

Previous Topic:	FRM-92100 Error in Oracle 10.1.0.4 under UNIX B.11.11
Next Topic:	(+) Operator

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 02:14:35 CST 2025