Re: Where is procedure text???

On Fri, 18 Dec 1998 17:13:20 GMT, alt_at_interchange.co.uk wrote:

>Can someone tell me if there is a table in the data dictionary that holds the
>syntax for procedures / packages that have been created by a user (like the
>text field in DBA_VIEWS) ?

Look at the USER_SOURCE view (or DBA_SOURCE if you prefer). To see the source for a function named MY_FUNC, issue a select like this:

	select text
	from user_source
	where name=MY_FUNC
	and type='FUNCTION'
	order by line;

regards,

Jonathan Received on Fri Dec 18 1998 - 19:38:42 CST