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

Thread: How to view the procedure

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    17
    How to view the exisiting procedure in oracle 8i and how to describe the procedure.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    from user_source, all_source, dba_source

    desc procedure_name in sql*plus

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    As Pando said, you can see it from User_Source, All_Source etc., but normally when you move your
    application from development to production environment you should wrap the Pl/Sql stored objects, so that
    others will not be able to see the source code of it.

    Vijay.
    Say No To Plastics

  4. #4
    Join Date
    Feb 2001
    Posts
    180
    Use a tool like TOAD or PLSQL-developer
    Regards
    Ben de Boer

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