Example 1: Using ALTER PROCEDURE to target a new routine and
    sharable image

    This example shows ALTER PROCEDURE updating the location, routine
    name and language for an external procedure.

    SQL> show procedure SEND_MAIL
    Information for procedure SEND_MAIL

     Procedure ID is: 261
     External Location is: SYS$SHARE:SENDMAILSHR.EXE
     Entry Point is: SEND_MAIL
     Language is: COBOL
     GENERAL parameter passing style used
     Number of parameters is: 2

    Parameter Name                  Data Type        Domain or Type
    --------------                  ---------        --------------
    USR                             CHAR(30)
            Parameter position is 1
            Parameter is IN (read)
            Parameter is passed by reference

    TXT                             VARCHAR(1000)
            Parameter position is 2
            Parameter is IN (read)
            Parameter is passed by reference

    SQL> /*
    ***> The routine has been rewritten.  Use ALTER PROCEDURE
    ***> to retarget the external routine to use the new
    ***> implementation, instead of using DROP/CREATE
    ***> */
    SQL>
    SQL> set quoting rules 'SQL99';
    SQL>
    SQL> alter procedure SEND_MAIL
    cont>     name "send_mail_ext"
    cont>     location 'SYS$SHARE:SENDMAILSHR30.EXE'
    cont>     language C
    cont>     comment 'Use new V3.0 interface routine';
    SQL>