Finally, sftp from an Oracle database using plain plsql 20188367001

Finally, sftp from an Oracle database using plain plsql

Just a quick blog to get me through the Christmas eve. More than 5 years ago I wrote a blog about FTPS from an Oracle databse. In that blog I already mentioned that SFTP using plsql is possible. Not loading some Java classes in the database and adding some plsql wrappers. No, just plain old plsql. At that time I had a “prove of concept”-script which was huge.

But, after moving almost all encrypting/decrypting code to as_crypto, I switched to using dbms_crypto instead of my own code. And it turns out that transferring files to or from a SFTP-server can be done using a small package with less than 3000 lines of code, as_sftp.

At this moment it is only possible to use a user/password to login to the SFTP-server, but if I have time (might take another 5 years 😁) I will add code to use a private RSA key to login

Anton

Tags:,

88 Comments

  1. Eli Ivanir May 11, 2023
  2. Eli Ivanir April 26, 2023
  3. zak June 15, 2022
  4. Julien March 22, 2022
    • Anton Scheffer March 22, 2022
  5. Lee T. Lindley January 18, 2022
  6. K Sandberg January 11, 2022
    • Anton Scheffer January 11, 2022
    • KSandberg January 11, 2022
      • Anton Scheffer January 14, 2022
  7. Renno Kullerkupp December 7, 2021
    • Anton Scheffer December 7, 2021
    • Renno Kullerkupp December 8, 2021
      • Anton Scheffer December 8, 2021
  8. Hardian September 2, 2021
    • Anton Scheffer September 2, 2021
      • Hardian September 6, 2021
        • Anton Scheffer September 6, 2021
          • Hardian September 6, 2021
  9. Christian Krex August 3, 2021
    • Anton Scheffer August 3, 2021
  10. celso July 3, 2021
  11. Vinicius Damarques December 11, 2020
    • Anton Scheffer December 11, 2020
  12. Todd Barry November 5, 2020
    • Anton Scheffer November 5, 2020
      • Todd Barry December 3, 2020
  13. Kannan October 20, 2020
    • Anton Scheffer October 20, 2020
      • Kannan October 21, 2020
        • Anton Scheffer October 21, 2020
          • Kannan October 21, 2020
          • Anton Scheffer October 21, 2020
          • Kannan October 21, 2020
          • Anton Scheffer October 21, 2020
          • Kannan October 21, 2020
          • Anton Scheffer October 21, 2020
          • Kannan October 21, 2020
        • Kannan October 26, 2020
          • Anton Scheffer October 26, 2020
  14. Swastik Panigrahi September 29, 2020
    • Anton Scheffer September 29, 2020
  15. Bhumika Gogia September 28, 2020
    • Anton Scheffer September 28, 2020
      • Bhumi October 6, 2020
        • Anton Scheffer October 6, 2020
          • Bhumi October 6, 2020
          • Anton Scheffer October 6, 2020
      • Bhumi October 7, 2020
        • Anton Scheffer October 7, 2020
          • Bhumi October 12, 2020
          • Anton Scheffer October 12, 2020
  16. Ricardo September 16, 2020
    • Anton Scheffer September 16, 2020
  17. Aswathy September 7, 2020
    • Anton Scheffer September 7, 2020
      • Aswathy September 7, 2020
        • Anton Scheffer September 7, 2020
          • Aswathy September 8, 2020
          • Anton Scheffer September 8, 2020
  18. Aswathy September 3, 2020
    • Anton Scheffer September 3, 2020
      • Tirupati S Vidap October 7, 2020
        • Anton Scheffer October 7, 2020
          • Tirupati S Vidap October 8, 2020
          • Anton Scheffer October 12, 2020
          • Tirupati S Vidap November 20, 2020
          • Anton Scheffer November 20, 2020
          • Tirupati S Vidap November 24, 2020
        • Tirupati S Vidap December 3, 2020
          • Anton Scheffer December 3, 2020
  19. Nelson July 30, 2020
  20. Nelson July 28, 2020
    • Anton Scheffer July 29, 2020
  21. Levent March 25, 2020
    • Levent March 25, 2020
    • Anton Scheffer March 25, 2020
      • Levent March 26, 2020
  22. Todd Barry January 15, 2020
    • Anton Scheffer January 15, 2020
  23. felix January 15, 2020
    • Anton Scheffer January 15, 2020
  24. Morgan January 10, 2020
    • Anton Scheffer January 10, 2020
      • Herbert Broich July 16, 2021
        • Anton Scheffer July 17, 2021
          • Anil January 18, 2022
  25. Todd Barry January 3, 2020