What are external procedures ? Why and when they are used?

Showing Answers 1 - 10 of 10 Answers

Tina

  • Aug 2nd, 2006
 

I hope external procedures are Extended stored procedures only.they let you create your own external routines in a programming language such as C.Extended stored procedures are DLLs that an instance of Microsoft SQL Server can dynamically load and run.Extended stored procedures run directly in the address space of an instance of SQL Server and are programmed by using the SQL Server Extended Stored Procedure API.

  Was this answer useful?  Yes

TinaBhate

  • Aug 2nd, 2006
 

Extended stored procedures let you create your own external routines in a programming language such as C. Extended stored procedures are DLLs that an instance of Microsoft SQL Server can dynamically load and run. Extended stored procedures run directly in the address space of an instance of SQL Server and are programmed by using the SQL Server Extended Stored Procedure API.

  Was this answer useful?  Yes

lalita.p

  • Oct 2nd, 2006
 

Extended store procedures are the Functions written in DLL.

  Was this answer useful?  Yes

External procedures provide a mechanism for calling out to a non-database program, such as a DLL under NT or a shared library under Unix. Every session calling an external procedure will have its own extproc process started by the listener. This extproc process is started with the first call to the external procedure and terminates when the session exits. The shared library needs to have a corresponding library created for it in the database.

  Was this answer useful?  Yes

An external procedure, also sometimes referred to as an external routine, is a procedure stored in a dynamic link library (DLL), or libunit in the case of a Java class method. You register the procedure with the base language, and then call it to perform special-purpose processing.

For instance, when you work in PL/SQL, the language loads the library dynamically at runtime, and then calls the procedure as if it were a PL/SQL subprogram.

REFERENCE FROM ORACLE SITE :

http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg11rtn.htm#1000718

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions