Wednesday, November 15, 2006

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.

4 comments:

Anonymous said...

You need to take part in a contest for one of the finest websites on the internet.
I am going to highly recommend this website! dream marriage
My web site :: telegraph dating

murali karthik said...

Hi friends, This is Murali from Chennai. I am a technology freak. Your technical information is really useful for me. Keep update your blog.
Regards..
Oracle Training

mythily mythu said...

oracle training in chennai

mythily mythu said...

nice posting...
informatica training in chennai