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
Using %ROWTYPE The %ROWTYPE attribute gives a record type which represents a row in a table (or view). The record can store the whole row of data selected from the table or fetc

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Example of NOT EXISTS in SQL Example: Use of NOT EXISTS CREATE ASSERTION Must_be_enrolled_to_take_exam_alternative1 CHECK ( NOT EXISTS (SELECT StudentId, CourseId

Use Native Dynamic SQL A few programs (a normal-purpose report writer for illustration) should build and process a variety of SQL statements at run time. Therefore, their full

LOB Types The large object (LOB) datatypes like BFILE, BLOB, CLOB, and NCLOB store the blocks of unstructured data (like graphic images, text, video clips, and sound waveforms)

IN OUT Mode An IN OUT parameter passes initial values to the subprogram being called and return efficient values to the caller. Within the subprogram, an IN OUT parameter acts

Dynamic Ranges The PL/SQL lets you determine the loop range dynamically at run time, as the example below shows: SELECT COUNT(empno) INTO emp_count FROM emp; FOR i IN 1..emp_cou

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Using EXISTS The EXISTS(n) returns TRUE if the nth element in a collection exist. Or else, EXISTS(n) returns FALSE. Primarily, you use EXISTS with DELETE to maintain the spars

This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so