STORED PROCEDURES 1

[Mike29Palms]

Is there a way to retrieve the text of a stored procedure from the data dictionary?

 

[jimbopalmer]

desc all_source as system

something like select text from all_source where name = 'MY_PROCEDURE' and type = 'PROCEDURE' order by line;

I am not right at my databasse to get exact column names, but that is real close

I tried to remain child-like, all I acheived was childish.

 

[Mike29Palms]

Can you do a the same to pull out insert statements that populated tables in your database?

 

[jimbopalmer]

You can search all_source for INSERT but that will only find inserts in functions, procedures and package bodys not in forms or triggers.

Select distinct name, owner from all_source where upper(text) like '%INSERT%';

I tried to remain child-like, all I acheived was childish.