This discussion is archived
1 Reply Latest reply: Sep 6, 2011 6:05 AM by user130038 RSS

Can v read a client text file using SQL*plus??

722624 Newbie
Currently Being Moderated
We have a requirement like this: We need to read a text file to find spelling mistakes. Problem is the file has to be always moved to the DB machine, which is a Linux box and then run a stored procedure which uses UTL_FILE. Now in order to show the spelling mistakes of the file the user will have to again copy the file with the spelling mistakses (output file) from Linux to Windows.

Is there a way to do it using SQL*Plus, where the text file is in the client machine???? Then users don't have to copy the file to and from the Linux box.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points