What is the Difference between stored procedures and external procedures?

Showing Answers 1 - 3 of 3 Answers

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.A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. This will be stored in oracle database.

  Was this answer useful?  Yes

g_sidhu1

  • Feb 21st, 2008
 

An external procedure is simply a program unit that is not written in Oracle’s SQL or PL/SQL and resides outside of the database. External procedures must be stored as shared libraries at the operating system level. In a Windows NT environment, the procedure would be compiled into a DLL.

  Was this answer useful?  Yes

sampra

  • Feb 26th, 2008
 

An external procedure is simply a program unit that is not written in Oracle’s SQL or PL/SQL and resides outside of the database. External procedures must be stored as shared libraries at the operating system level. In a Windows NT environment, the procedure would be compiled into a DLL.
where as stored procedure is written in sql

  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