Using external stored procedures is very similar to using stored procedures, except for the following:
- Invoking an external stored procedure from a client application does not affect the nesting limit for stored procedures.
- To install an external stored procedure on a database, you must have the CREATE EXTERNAL PROCEDURE privilege on the database.
- The CREATE PROCEDURE statement for external stored procedures is different from the CREATE PROCEDURE statement for stored procedures. In addition to syntax differences, you do not have to use the COMPILE command in BTEQ.