Use external routines - improve performance of application, PL-SQL Programming

Use External Routines

The PL/SQL is particular for the SQL transaction processing. Therefore, several tasks are more quickly completed in a lower-level language like C that is very efficient at the machine-precision calculations.

The PL/SQL extends the functionality of the Oracle server by providing an interface for calling routines written in other languages. The Standard libraries by now written and available in other languages can be called from the PL/SQL programs. These promote reusability, efficiency, & modularity.

To speed up execution, you can rewrite the computation-bound programs in C. In calculation, you can move these programs from client to server, where they will execute more rapidly thanks to less across-network communication and more computing power.

For illustration, you can write methods for an image object type in C, store them in a DLL (dynamic link library), register the library with the PL/SQL, and then call it from your applications. At run time, the library load dynamically and, for safety, runs in an individual address space.

Posted Date: 10/5/2012 4:57:31 AM | Location : United States







Related Discussions:- Use external routines - improve performance of application, Assignment Help, Ask Question on Use external routines - improve performance of application, Get Answer, Expert's Help, Use external routines - improve performance of application Discussions

Write discussion on Use external routines - improve performance of application
Your posts are moderated
Related Questions
Parameter Modes: You do not require to specify a parameter mode for the input bind arguments (those used, for illustration, in the WHERE clause) as the mode defaults to IN. Th

Usefulness of Data Type In SQL, as in most computer languages, a type can be used for constraining the values that are permitted to be used for some purpose. In particular, i

Multiple Assignment- SQL SQL supports multiple assignment to local variables and also applies multiple assignment semantics in SET clauses of UPDATE statements, but does not

Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

SQL Functions The PL/SQL uses all the SQL functions involving the following aggregate functions that summarize the whole columns of the Oracle data: GROUPING, AVG, COUNT, STDDE

Need Database Development with Analysis Tools Project Description: I want a database for large governmental and private data sets on one country that can be simply extended t

Write a pl/sql block that declares and uses cursors with parameters. In a loop, use a cursor to retrieve the department number and the department name from the departments table

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

%ISOPEN The %ISOPEN yields TRUE if its cursor or cursor variable is open; or else, the %ISOPEN yields FALSE. In the illustration, you use the %ISOPEN to select an action:

Comparison Operators Usually, you use the comparison operators in the WHERE clause of a data manipulation statement to form the predicates, that compare one expression to anot