Replacing copies of a package for a version of a native SQL procedure

When you change a version of a native SQL procedure and the ALTER PROCEDURE REPLACE statement contains certain options, you must replace any local or remote copies of the package that exist for that version of the procedure.

About this task

If you specify any of the following ALTER PROCEDURE options, you must replace copies of the package:
  • REPLACE VERSION
  • REGENERATE
  • DISABLE DEBUG MODE
  • QUALIFIER
  • PACKAGE OWNER
  • DEFER PREPARE
  • NODEFER PREPARE
  • CURRENT DATA
  • DEGREE
  • DYNAMICRULES
  • APPLICATION ENCODING SCHEME
  • WITH EXPLAIN
  • WITHOUT EXPLAIN
  • WITH IMMEDIATE WRITE
  • WITHOUT IMMEDIATE WRITE
  • ISOLATION LEVEL
  • WITH KEEP DYNAMIC
  • WITHOUT KEEP DYNAMIC
  • OPTHINT
  • SQL PATH
  • RELEASE AT COMMIT
  • RELEASE AT DEALLOCATE
  • REOPT
  • VALIDATE RUN
  • VALIDATE BIND
  • ROUNDING
  • DATE FORMAT
  • DECIMAL
  • FOR UPDATE CLAUSE OPTIONAL
  • FOR UPDATE CLAUSE REQUIRED
  • TIME FORMAT

To replace copies of a package for a version of a native SQL procedure, specify the BIND COPY ACTION(REPLACE) command with the appropriate package name and version ID.