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
Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL

Oracle 10G new features:- Automatic Database Diagnostic Monitor System Advancements - these methods will provides several methods for extracting reports through the Automatic

Object Types An object type is a user-defined complex datatype which encapsulates the data structure along with the functions and procedures required to manipulate the data. Th

Defining and Declaring Collections To create the collections, you must define a collection type, and then declare the collections of that type. You can define the VARRAY types a

Parameter and Keyword Description: type_name: This identifies a user-defined type specifier that is used in the subsequent declarations of the objects. AUTHID Clause:

Delimiters A delimiter is a simple or compound symbol which has a special meaning to PL/SQL. For example, you use delimiters to symbolize an arithmetic operation like additio

Initializing Records The illustration below shows that you can initialize a record in its type definition. Whenever you declare a record of the type TimeRec, its 3 fields supp

In Packages The Forward declarations also group logically related subprograms in the package. The subprogram specifications go in the package specification, & the subprogram b

LAWS / RULES - Dollo's Law                     :           Living organisms do exhibit evolutionary irreversibility or evolution is irreversible. Williston's Law

Using a join on 3 tables, select 5 columns and 10 rows from the 3 tables without the use of a Cartesian product Query: SELECT E.LAST_NAME, E.FIRST_NAME, S.BUILDING, S.BRAN