Home » SQL & PL/SQL » SQL & PL/SQL » update a field on a table depending on file created on sun server (Oracle 10g on Sun Server)
update a field on a table depending on file created on sun server [message #352523] Wed, 08 October 2008 03:36 Go to next message
ShaShalini
Messages: 59
Registered: January 2007
Member
Hello Everybody

I have to write a stored procedure to update a table date field depending on a file created on sun server.

E.g
File created on server is
/apps/load/cur.txt

I need to go to that specific directory and search if there are any txt files created.

If yes then I need to updated a tables having records containing the filename and update the date field depending on the date found on the sun server for that file and then delete the file from the server.

Can you give me an idea how to read the file from server.

Thanks

Re: update a field on a table depending on file created on sun server [message #352524 is a reply to message #352523] Wed, 08 October 2008 03:49 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Can you give me an idea how to read the file from server

UTL_FILE

Remember Oracle is a data management tool NOT a file management tool.

Regards
Michel
Previous Topic: finding time elapsed between two dates
Next Topic: help with CASE
Goto Forum:
  


Current Time: Sun Feb 09 08:19:52 CST 2025