|
This package provides fully fledged FTP client functionality from inside PL/SQL, making it UTL_FTP by another name.
Unlike other PL/SQL FTP solutions, this is the only package that concentrates on the underlying reason for wanting to transfer files
using PL/SQL: namely, to load data from files into the database or unload data to files. This package is implemented solely in PL/SQL and requires
no other Java classes to be loaded, installation is simply running a SQL script!
The 'killer app' that XUTL_FTP implements is 'remote external table' like abilities*. There is no other word for it, allowing a file on a FTP server
to be viewed as a table in the same way that EXTERNAL TABLES allow the querying of OS files local to the database server.
This vastly simplifies the data loading process by turning OS dependant implementations that use shell scripts into a stored procedure that is easily
scheduled using DBMS_JOB. Less moving parts, no two stage processes, no disk required!
Normally flat files from remote systems are loaded by an operating system scheduler calling a shell script that:
- FTPs a file to the local disk
- calls a SQL*Plus script to load the file as an external table into a real table
Using XUTL_FTP, the process simply becomes:
- INSERT INTO... SELECT * FROM...
With XUTL_FTP the transferring of the file IS the data loading process.
The file is NOT copied to disk, it's simply 'poured' straight into whatever table you like!
If this wasn't enough, it also has the other following uses:
- unloading BLOBS to the database server file system (as UTL_FILE does not have a working binary implementation until 10g)
- arbitrary unloading of data to remote servers
- obtaining a file listing for a directory on the database server file system
And the package is fully instrumented, exposing the progress of all PUT and GET operations in the form of views that can be queried from other sessions.
The full range of functionality is:
- GET text files from a FTP server into arrays, CLOBs or UTL_FILE file handles
- GET binary files from a FTP server into BLOBs
- PUT CLOBs, arrays, UTL_FILE handles or REF CURSOR queries into text files on a FTP server
- PUT BLOBs and BFILEs into binary files on a FTP server
- list files in directories on a FTP server
- create and delete directories on a FTP server
All functionality is documented and code samples provided in the file xutlftp_spec.sql script in the installation download.
* Functionality requires 9i or greater database.
|
|
Download XUTL_FTP!
for 10g Release 1
File Information
Name - xutlftp10g.rar
Size - 23KB
Version - 14.0
Date - 11 Dec 2006
xutlftp10g.rar
for 9i Release 2
File Information
Name - xutlftp9i.rar
Size - 74KB
Version - 14.0
Date - 11 Dec 2006
xutlftp9i.rar
for 8i
File Information
Name - xutlftp8i.rar
Size - 73KB
Version - 14.0
Date - 11 Dec 2006
xutlftp8i.rar |
|
|