Link to home
Start Free TrialLog in
Avatar of Swaminathan K
Swaminathan KFlag for India

asked on

need help Oracle database programming

Hi ,

I need to unwrap pl/sql code . I have the code which is spanned to 3 rows in all_source table.
I need to combine all the rows into single row and combine it and unwrap it.

I have attached the excel sheet which contains the data for all source table.

Any help in this regard is really appreciated.

rgds
sam
SampleData.xlsx
SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sam, you can query the E-E search engine for "plsql wrap", there are a number of good threads -- but your question is answered above.  Once wrap is applied to a procedure or function, your alternative is to find the unwrapped source in your site's version control tool.
If the developer didn't keep a backup copy of the source from before the wrap action, our sympathy.
Avatar of Swaminathan K

ASKER

hi

I have the source code available. Iam trying to see if we can get any tools which can unwrap the code. I have the below questions

1. How can I know which version of Oracle the pl/sql code is wrapped. The code is split into 3 rows in the all source data dictionary view . can you suggest any query that can change  3 rows into a single row .

2. Any tools available for unwrapping if it is wrapped in oracle 9i or below version of oracle.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks
Avatar of Sean Stuber
Sean Stuber

why the B?
Hi sdstuber,

I marked as B , I wanted solution for both my  queries , one is for the concatenating the sql from mutiple rows into single , that was awesome ...
Secondly , I wanted any tool available or a way (algorithm) if any to unwrap the code . I wanted this few of the source codes we have lost.

Otherwise , Iam grt admirer of your solutions , whenever I fire a question on oracle , you are there to answer it.

Please do not mistake ...

regds
Sam
I did not provide a tool for unwrapping 9i code because there isn't one that I know of.

Pete Finnigan wrote a white paper that outlines how wrapping occurs, it is "in theory" possible to reverse those instructions to create an unwrapper.  

http://www.blackhat.com/presentations/bh-usa-06/BH-US-06-Finnigan.pdf

Note, you will NOT find the tool you are looking for in this document. Nor will you find the source code or even a complete instruction set.  You'll find an outline.  I did not provide this earlier because it's clearly not what you want, but it's as good as you're likely to find.

I know of only one commercial product that claims to be able to unwrap 9i code, I have no idea if it will or how well.  Nor can I recommend the vendor, I know nothing about them to say one way or the other.  Since finding them is an obvious google, I have to assume you dismissed them as well.