Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reverse engineering of compiled function or procedure
No problem Frank, just glad that it was what you were looking for.
You can also get fancy with it and BREAK on the NAME column (etc), format the data, then spool it out, so you have the complete text of the code for recompiling without a lot of editing for readability.
Cheers,
Brick
Frank wrote:
>
> Bricklen,
>
> The script provided what exactly I'm looking for. I also got your email.
> Thanks a lot! Appreciate for sharing your expertise!
>
> Frank
>
> Bricklen Anderson <bricklen_at_shaw.ca> wrote in message news:<3CB33952.49CC3468_at_shaw.ca>...
> > 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
Received on Tue Apr 09 2002 - 19:01:00 CDT