Re: Reverse engineering of compiled function or procedure

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
Received on Tue Apr 09 2002 - 13:59:49 CDT