Procedure path

[helpme]

hi,
where in the OS can i find all my procedures?
like /usr/proc?
thanx in advance

[moff]

Hi,

I think procedures are like tables and are actually stored in the database, you can't go to a directory and view/edit them.

Cheers

Moff.

[helpme]

i just saw this url

http://kontti.helsinki.fi:8889/ows-adoc/plaex2.htm

Which states that we call call proc from web pages
Was just curious as to what pathto give ....

thanx

[santoshym]

Hi

Offcourse the procedures are stored in the database until and unless you have explicity saved them on the hard disk which usually everybody does.But you can have look at what procedures are available on your database using the following query

select * from user_source;

select * from all_source;

select * from dba_source;

Regards