Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting Stored Procedures source.
Well actually, I believe it is a view(s).
look at
dba_source
user_source
.
Deepak Hathwar wrote in message <365D971D.78E26076_at_charlotte.infi.net>...
>Hi:
>Is it possible to get the code from the database that is used by
>Migration workbench for all the stored procedures. I would like to write
>some Java programs to do this. Moreover, I would like to get the
>procedures before they are parsed into the Oracle database. What is the
>name of the table that contains all the source for the stored
>proecdures?
>
>Thanks in advance.
>Deepak Hathwar
>
Received on Thu Nov 26 1998 - 12:23:34 CST