Procedures

[mooks]

Hi,

I am currently looking for the codes of all procedures. Is there a table which will stored all the procedures? If yes, which table? Thanks. :)

[gsprince]

I guess, u can use ALL_SOURCE table.

[vimalp]

Hi gsprince,
i think you are right!
mooks, you can also try DBA_SOURCE and make sure
you use 'text' instead of '*' and 'line number'.
like: select text, line number from
DBA_SOURCE
order by line number;

correct me if i'm wrong!

HTH,