1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to wrap and unwrap PKGS?

Discussion in 'SQL PL/SQL' started by Vicky, Apr 1, 2015.

  1. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    Hi all...

    Cud U tel me how to wrap the PKGS(which are been already created) and how to unwrap the same.!?
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You really can't 'unwrap' wrapped code as Oracle doesn't provide such a utility; once code it wrapped it remains that way so you really should keep a plain-text copy in a separate location so it can be modified, if need be. I blogged on that very subject 7 years ago:


    https://dfitzjarrell.wordpress.com/2008/06/02/thats-a-wrap/
     
    Vicky likes this.
  3. Vicky

    Vicky Forum Advisor

    Messages:
    261
    Likes Received:
    11
    Trophy Points:
    260
    Location:
    Chennai
    Tks David., Cud U share any blog regarding DBMS_ALERT functionality with simple examples.,?
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    That's one I need to write, thanks for the suggestion.
     
  5. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Vicky likes this.