All geek questions in one place

Is it possible to save to ftp txt directly from the Store procedure in Oracle?

I need to generate txt from oracle and put it in the ftp server, I already create st to build the file, but is it possible to transfer it to ftp directly from SP ???

Thank.

+3
source share
1 answer

you are sure you can (you don’t know which version of Oracle you are using, but while it’s 9i ++, you should be safe).

UTL_FILE ( ), utl_tcp ( ftp'ing ).
( ) . http://www.oracle-base.com/articles/misc/FTPFromPLSQL.php

+3

Source: https://habr.com/ru/post/1770942/

More articles:


All Articles