Oracle 9i Native Compiled PL/SQL, where is the location of the external stored libs?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle 9i Native Compiled PL/SQL, where is the location of the external stored libs?

  1. #1
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    Oracle 9i Native Compiled PL/SQL, where is the location of the external stored libs?

    Hi,
    Oracle 9i R2

    I would like to know where Oracle stores the external refereence to it's pl/sql-object when it's native compiled.
    Regards
    Orca

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi amar,
    thank you!
    i looked at the article but nothing about a view which shows external path of the internal pl/sql-object. :-(

    PS.: i like your phrase : "There is a difference between knowing the path and walking the path."

    it's spiritual deeply true!

    Orca

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Try all_stored_settings,dba_stored_settings,user_stored_settings... Though im not sure if this what you are looking for...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    No, sorry
    this views show only the state of Pl/Sql-object but not the
    storage-place on filesystem.
    Orca

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    AFAIK the location of the library storage is defined by the parameter

    PLSQL_NATIVE_LIBRARY_DIR

    But if you are looking for a view or a table that shows the exact file name that was generated with native compilation, then i haven't seen any such view which shows the name of the library generated. May others can help on this.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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