OraFAQ Forum: Forms » open text file using oracle form

Home » Developer & Programmer » Forms » open text file using oracle form

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

open text file using oracle form [message #79616]

Thu, 27 June 2002 02:01

ranjan kumar dash
Messages: 15
Registered: February 2002

Junior Member

Hi all,
My query is that
I have file1.txt in comp1,file2.txt in comp2,file3.txt in comp5 means different file in different computer.These file have some meanigful data.Now we will crete a table in Oracle that is filename and desc.Then insert file1 and in desc part of content of the text file.Loke this add all the file now in the form level make a push button when i will press the push button user can open the text file.

Report message to a moderator

Re: open text file using oracle form [message #79646 is a reply to message #79616]

Sun, 30 June 2002 22:05

Balamurugan.R
Messages: 91
Registered: March 2001

Member

Hi

Use Text_io package to solve this problem.

Use get_file_name , a window will open asks file

to open. Now u get the full path of the file name

to open. Now use text_io.fopen with read mode.

Then read every line into the textbox. Goto the

help get the full information about these functions,

u can solve your problems.

Hope this will give some idea.

With luv,
Balu

Report message to a moderator

Re: open text file using oracle form [message #79787 is a reply to message #79616]

Fri, 12 July 2002 02:59

NV
Messages: 6
Registered: June 2002

Junior Member

hai ..

Use the host command. It'll solve ur prob..
The syntax to open a file is as follows:
HOST('EXPLORER C:XYZTEMP.TXT');

Bye

Report message to a moderator

Previous Topic:	hierachial trees in forms
Next Topic:	passing parameter to reports from forms6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 23:56:15 CDT 2025