RE: What is the Difference between stored procedures a...
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.
RE: What is the Difference between stored procedures and external procedures?
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.
RE: What is the Difference between stored procedures and external procedures?
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
