Expert: Suchitra Joshi - 10/1/2009

Question
v can see the procedure that v created by select * from user_object where user_object ='procedure'.. but my question is how can v see the particular procedures code in from our orecal server..
plz reply me...

Answer
Hi Sneha,

To check your procedure code, you can check the table user_source or all_source.

select line, text
from user_source
where name = 'XXXX'
order by line;

Here XXXX is the procedure name (in caps). You will get all your code line by line (the format is not proper).

Hope this helps.

Regards

Suchitra