• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 689
  • Last Modified:

Browse / Delete files in remote server using SQLPlus or Pl/SQL triggers

How I can Browse / Delete files in remote server using SQLPlus or Pl/SQL triggers

That I can access oracle database from client machine
0
egovernment
Asked:
egovernment
1 Solution
 
slightwv (䄆 Netminder) Commented:
>>How I can Browse / Delete files in remote server using SQLPlus or Pl/SQL triggers


You can see files using if UTL_FILE_DIR or database directories are set up.  There are also some products like Internet File System (not sure what it is called today).

Now can you 'browse' them?  I'm not sure of a way to say "give me a list of all files in the folder".  I don;t see anything in utl_file for that:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/u_file.htm#ARPLS70906

Not saying it doesn't exist, just not aware of a way.

>>That I can access oracle database from client machine

Many ways.  What tools are available to you?  

For example:

If .Net/Java, then you can stream the contents.

If sqlplus, you can probably spool the output with a little smoke and mirrors.
0
 
sdstuberCommented:
it's not really the intended purpose but you might be able to do some of what you need with the ftp package here...


http://www.experts-exchange.com/Database/Oracle/PL_SQL/A_3043-How-to-FTP-with-Oracle-PL-SQL.html

The FTP functionality includes directory listing and removal capabilities in addition to the the file transfers.  You would, of course, be limited to the filesystems exposed by the ftp server.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now