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
%ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche

Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th

%FOUND Subsequent to a cursor or cursor variable is opened but before the first fetch, the %FOUND yields NULL. Afterward, it yields TRUE when the last fetch returned a row, or

Relational Algebra - SQL It describes some operators, that together constitute an algebra that is not only relationally complete but also irreducibly so (very nearly- apart f

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Anatomy of a Command Figure, showing a simple SQL command, is almost identical to its counterpart in the theory book. The only difference arises from the fact that SQL uses a

Deriving Predicates from Predicates in SQL The corresponding section in the theory book describes how predicates can be derived from predicates using (a) the logical connectiv

WHEN or THEN Key Constraints Suppose a table has two columns representing a period of time throughout which the information conveyed by the other columns is recorded as having

Anatomy of a Table: Figure shows the terminology used in SQL to refer to parts of the structure of a table. As you can see, SQL has no official terms for its counterpa

Block Structure The PL/SQL is a block-structured language. That is, the fundamental units (procedures, anonymous blocks, and functions) that make up a PL/SQL program are logi