Re: View function code

select * from user_source where name = 'MYFUNCTION' order by line;

The source is kept in dictionary tables and you have to select against those tables to find many types of information. You must be logged on as the user that owns the function in order to execute this command successfully.
If you are logged on as a user with the DBA privilege, then you can say:

select * from dba_source;
and you will see every line of source code in the database. You don't want to do this. But you can restrict the selection to the specific FUNCTION or PROCESS with an appropriate WHERE clause. Mike

"Just Me" <daizygirl999_at_hotmail.com> wrote in message news:961c53a9.0209120951.3e2e3261_at_posting.google.com...
> I'm new to Oracle. We have a pro c application that are calling
> Oracle functions. I "inherited" this application and I'm having a hard
> time sorting through the code and the database functions, procedures,
> etc.
>
> Anyway:
>
> The application is calling an Oracle function. I need to view the
> code for this function so I can figure out what it does. All I see is
> Create, Alter and drop. None of these help since I don't know what
> the heck the function is doing. Please help.
>
> Thank You!
> -JM
Received on Thu Sep 12 2002 - 20:40:52 CEST