SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to search a function name in a wrap source code user?

3018678Feb 26 2016 — edited Mar 2 2016

Hi All,

I have connect to DB as SYS user. One of the user has wrap source code (encrypted). This user call a function which name is MY_FUNC. I am tring to find out that when and how this user call the function (witch which parameters etc.)? When I run the following query. It cannot show the body part of the packages etc. because of wrap code. So, what can I do? What do you recommend?

There are web sites which unwrap the PL/SQL code. However, how can I take the whole code at one time, I mean , for example I can copy and paste the one of package code but there are more than 100 packages. I have to copy and paste it one time in orde rto use the web site. Otherwie it cannot be usefull.

select * from dba_source where owner = 'EUSER' and lower(text) like '%my_func%';

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2016

Added on Feb 26 2016

29 comments

4,059 views