How to find Wrapped objects in the database

Asked

Viewed 41 times

1

I have a database with several objects Wrapped, and I need a way to search and locate all objects that are encrypted, ie with the wrap, to subsequently have a treatment.

What are Wrapped objects:

"...We can and should protect our code in the database Oracle."

"...This protection can be done in our code, that is called wrap. That way we encrypt our code, making it unreadable for another person. Of course the recovery of a code with wrap is not impossible, but it certainly makes this process very difficult."
Source: wrap-Utility-encrypting-code

Object without a wrap:

CREATE OR REPLACE FUNCTION teste RETURN  NUMBER IS
BEGIN
RETURN 1;
END teste;
/

Object Wrapped:

CREATE OR REPLACE  FUNCTION teste wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
8
3d 71
m9n4KQ8rT+C9b7lU4HcO3pDzsUMwg8eZgcfLCNL+XhahYtGhXOfAsr2ym16lmYEywLIJpXSL
wMAy/tKGCamhBKPHvpK+FkZTOQdTo4KmpqsCL3g=

/
oracle oracle12c
  • 1

    https://stackoverflow.com/questions/5028977/search-for-wrapped-packages-procedures-in-oracle-sql

  • TOPP @Motta, creates a response with the reference I mark as solved :D

  • Do not allow answers only links , leaves quiet.

  • If you want you can do something like this: 1 or so 2 with some context and putting the SOEN code in the answer here, but you who knows :)

1 answer

1


Already published

select type, owner, name
from all_source
where line = 1
  and instr(text, 'wrapped') > 1;

Source

Browser other questions tagged oracle oracle12c

You are not signed in. Login or sign up in order to post.