Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Nov 27, 2002

Managing Processes for External Procedures in Oracle 8i/9i - Page 3

By DatabaseJournal.com Staff

Advantages of External Routines

External Routines offer the following advantages:

  1. Reusability, efficiency, and modularity.

  2. DLLs already written and available in other languages can be called from PL/SQL programs.

  3. The DLLs are loaded only when needed, so memory is conserved.

  4. The DLLs can be enhanced without affecting the calling programs.

  5. External Routines are used to interface with embedded systems, solve scientific and engineering problems, analyze data, or control real-time devices and processes.

  6. External Routines enable us to move computation-bound programs from client to server, where they will execute faster thanks to more computing power and less across-network communication.

  7. Interface the database server with external systems and data sources.

  8. Extend the functionality of the database server itself.

Disadvantages of External Routines

The disadvantages of using the External Routines are:

  1. The EP feature is only available on platforms that support DLLs or Shared Object libraries.

  2. Routines are only callable from C code (not C++).

  3. You cannot pass PL/SQL cursor variables, records, collections, or instances of an object type to an external Routine.

  4. You cannot use Remote Server/Distributed processing using the CREATE LIBRARY clause.

  5. The extproc must be started on the same server where the extprocs are being used.

  6. The maximum number of parameters that you can pass to a C external Routine is 128. Limit on the same depends on the OS you use.

Ajay Gursahani, Mahindra-British Telecom Limited
E-mail: ajay.gursahani@mahindrabt.com

Oracle Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM