PL/SQL (MOSC)

MOSC Banner

Can wrapped code be saved to PKB and PKS files to be reloaded on to different instances?

edited Jan 12, 2011 10:18PM in PL/SQL (MOSC) 7 commentsAnswered ✓
We have a vendor that provides their code in wrapped packages.  We've asked for a revision of the code.  They change their source code and then wrap the code and provide us the wrapped package body and spec files to load into our database.

We want to test the changes on a test instance, however the regression testing is failing.  Production still works fine.

We would like to be able to revert our test instance code back to production's versions, however when we try to save the wrapped version of the files from our production instance (in TOAD), they save properly, but we receive a PLS-00753 error on the body only when we try to load it back in.  MOS says that TOAD shouldn't be used for loading/saving wrapped packages, but it offers no other suggestions on tools to use to save a wrapped package.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center