Procedure path
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Procedure path

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    hi,
    where in the OS can i find all my procedures?
    like /usr/proc?
    thanx in advance

  2. #2
    Join Date
    Feb 2000
    Posts
    175
    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.

  3. #3
    Join Date
    Jun 2001
    Posts
    316
    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

  4. #4
    Join Date
    Mar 2001
    Posts
    635
    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
    Santosh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width