Path: news.easynews.com!easynews!peer1-sjc1.usenetserver.com!usenetserver.com!pd2nf2so.cg.shawcable.net!residential.shaw.ca!news2.calgary.shaw.ca.POSTED!not-for-mail
X-Trace-PostClient-IP: 24.66.168.145
Message-ID: <3CB33952.49CC3468@shaw.ca>
From: Bricklen Anderson <bricklen@shaw.ca>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Reverse engineering of compiled function or procedure
References: <2ac74cf9.0204091030.7f0e4ed9@posting.google.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 21
Date: Tue, 09 Apr 2002 18:59:49 GMT
NNTP-Posting-Host: 24.64.223.206
X-Complaints-To: abuse@shaw.ca
X-Trace: news2.calgary.shaw.ca 1018378789 24.64.223.206 (Tue, 09 Apr 2002 12:59:49 MDT)
NNTP-Posting-Date: Tue, 09 Apr 2002 12:59:49 MDT
Organization: Shaw Residential Internet
Xref: easynews comp.databases.oracle.server:142537
X-Received-Date: Tue, 09 Apr 2002 11:57:33 MST (news.easynews.com)

try this to get the source:

SET linesize 1000
COLUMN text format a500
COLUMN line heading 'Line|number' format 9999 justify center
SELECT s.name,s.type,o.status,s.line,s.text
FROM user_source s, user_objects o
WHERE s.name=o.object_name;
clear columns

Frank wrote:
> 
> Hi All
> 
> After compiling a function or procedure in Oracle, is there any way to
> reverse engineer them? What I mean here is to view the content first
> (maybe export to text file), then re-compile them after modification.
> 
> Appreciated for sharing your thoughts.
> 
> Frank