AOL-Concurrent Program Types
1
Outline
► What is Concurrent Program
► Types and Purpose of Concurrent Programs
2
What is Concurrent Program?
3
Types and Purpose of CP
Type Programming Purpose
Language
PL/SQL Stored Procedure PLSQL 1. Data Validation
2. Invoke Other PLSQL API’s
3. Invoke Standard CP
4. Outbound Interface
Oracle Reports SQL/PLSQLL 1.Generate Reports
2. HTML/TXT/PDF
Host Shell Script 1. To Invoke PLSQL/SQLLoader
Programs
2. To Perform OS Level
Functionalities effectively – like
file copy
SQL *Loader SQLLoader Control 1. Inbound Interface
File
SQL *Plus SQL/PLSQL 1.Outbound Data Extract
Java Concurrent Program Java 1. For XML Publisher
4
Reports(XDODTEXE)