Oracle Apps:Concurrent programs different Execution Methods

Following are the possible execution methods which are commonly used in oracle applications Concurrent programs.

• * Oracle Reports – used for the RDF reports
• * Host – used for shell scripts, basically the language of the host operating system
• * PL/SQL Stored procedure – used to run the stored procedure through oracle applications
• * SQL*Loader – used to run the sql loader programs
• * SQL*Plus - used to run the anonymous PL/SQL blocks. It will get executed in the same fashion as
• you are running on SQL Plus.
• * Java Stored Procedure – The execution file is a Java stored procedure.
• * Java Concurrent Program – Used for program written in Java.
• * Spawned – used for c or pro*c Program. Mainly used by standard oracle interfaces.
• * Perl Concurrent Program – used for programs written in CGI Perl.
• * Request Set Stage Function – PL/SQL stored function that can be used to calculate the
• completion statuses of request set stages.
• * Immediate – execution file is a program written to run as subroutine of the concurrent manager.
• Oracle doesn’t recommend use of this executable type.
• * Multi-Language function – execution file is an MLS function that supports running concurrent program in multiple languages.

PL/SQL Stored Procedure, Oracle Reports, Host, SQL*loader, SQL*Plus, Java Concurrent Program are the most commonly used executable types.