0

Possible Duplicate:
How to write a file into sftp using Oracle pl/sql?

i read through couple of articles and past posts here, but would like to see if Oracle had this feature included in any of their recent releases.

Does Oracle database have any SFTP libraries or functions or utilities ?

Community
  • 1
  • 1
yathirigan
  • 5,619
  • 22
  • 66
  • 104
  • [Searching the documentation](http://www.oracle.com/pls/db112/search?word=sftp&partno=) suggests not, as do the previous answers here, though you can [roll your own](http://stackoverflow.com/a/11782580/266304). Have you read articles that suggest there is some built-in functionality? – Alex Poole Aug 03 '12 at 19:17
  • @AlexPoole nope, i haven't read any article quoting about built-in functionality.. it's surprising.. since these articles talked about past oracle releases, i wanted to cross check if any recent oracle release included this feature.. looks like it's a NO .. thnx for the other pointers.. – yathirigan Aug 04 '12 at 03:31
  • What do you actually want to achieve? – steve Aug 04 '12 at 18:19
  • @steve one of our oracle procedures will extract data from a table and create an excel/csv file out of it. This file needs to be transferred to a file server via SFTP. Rather than calling an UNIX sftp script or a Java program for SFTP, we were looking for an Oracle Native solution like the FTP library from oracle – yathirigan Aug 04 '12 at 21:03
  • This sounds like the wrong design. This is the job of a client program. Especially if you think about security domains. – steve Aug 05 '12 at 08:00
  • @steve our client program is a web page. A button click in the web page has to invoke this oracle procedure which can extract data & place it as an csv/excel file in another file server. What would be your suggestion in this scenario ? – yathirigan Aug 05 '12 at 13:14

1 Answers1

0

Question - Does Oracle database have any SFTP libraries or functions or utilities ?

Answer - No. There is for FTP but not SFTP.

Anjan Biswas
  • 7,746
  • 5
  • 47
  • 77