Read File from Unix (Database server) [message #451548] |
Thu, 15 April 2010 06:20 |
bahubcd
Messages: 40 Registered: July 2007 Location: Bangalore
|
Member |
|
|
Dear all,
I tried to search this forum, but some how I feel my question is so simple and straight forward that I was not able to get the direction from the answers given to very complicated questions.
I need to develop a form which has to read and display the contents of a text file that is stored in the Unix system where the Oracle data base is installed. So basically its the database server and not the forms application server.
Which approach do I follow and is easy to implement.
1. Create an external table for the file everytime when the form is loaded by dropping and re creating the table and base the data block in the form on that table and execute_query and display the contents.
2. I am confused whether to use webutil or utlfile packages to read from the file and display on the screen as the file resides in the database or Oracle server and not forms application server or client machine.
3. Any other suggestions from the form Gurus.
Appreciate any advise or help in this regards from you all.
Have a nice day,
Bahubcd.
|
|
|
|
Re: Read File from Unix (Database server) [message #451570 is a reply to message #451555] |
Thu, 15 April 2010 08:42 |
bahubcd
Messages: 40 Registered: July 2007 Location: Bangalore
|
Member |
|
|
Thank you very much LF for your reply,
But anyway, If I have to read it from a file directly and display it on the form, then how can I do it? (keeping in mind that the text file is on the data base server).
Just to see if I get an idea of doing it better what I am planning to implement.
Thanks and Regards,
Bahubcd
|
|
|
|
|
|