My Oracle Support Banner

OS Interaction Through PL/SQL (Doc ID 199223.1)

Last updated on OCTOBER 19, 2019

Applies to:

PL/SQL - Version 8.1.7.0 and later
Information in this document applies to any platform.
***Checked for relevance on 30th Jan 2019***

Purpose

PL/SQL developers often need their code to interact with the Operating System in which the program is running, and/or the Session of the user. There are numerous requirements( example ftp , mail ,executing os commands etc ..) for which the developer needs to interact with the Operating System .This Article addresses those requirements as well as general Solutions to interact with the Operating system and troubleshooting any errors which occur .

Scope

For Application Developers whose PL/SQL programs need to interact with OS facilities which are not directly supported by PL/SQL.

Some of the requirements are :

1. Running Operating system commands from PL/SQL
2. Doing FTP from PL/SQL
3. Sending email from PL/SQL
4. Accessing Environment variables from PL/SQL
5. Passing Environment variables to PL/SQL
6. Calling external Procedures from PL/SQL
7. Writing the contents of BLOB/CLOB to a file and vice versa from PL/SQL


OS INTERACTION THROUGH PL/SQL (OS COMMANDS, EMAIL ,FTP ,EXTERNAL PROCEDURES)

The Application Developer requires that he use OS provided facilities , external programs inside PL/SQL for the features which are not directly supported by PL/SQL.

Some of the requirements are:

1. Running Operating system commands from PL/SQL
2. Doing FTP from PL/SQL
3. Sending email from PL/SQL
4. Accessing Environment variables from PL/SQL
5. Passing Environment variables to PL/SQL                                               
6. Calling external Procedures from PL/SQL
7. Writing the contents of BLOB/CLOB to a file and vice versa from PL/SQL
8. Trouble Shooting

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.