Migrating native SQL procedures from test to production

When migrating native SQL procedures from a test environment to production, you do not need to determine whether you want to recompile to create new object code and a new package on the production server.

Procedure

To migrate a native SQL procedure from a test environment to production:

Reissue the same CREATE or ALTER statements used in the test environment in the production servers.