info about stored procedures and functions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: info about stored procedures and functions

  1. #1
    Join Date
    Dec 2000
    Posts
    255
    Hi All

    I have a few questions on Stored procedures and functions.

    From which view in Data Dictionary I can see the details of procedure and function and Packages?

    To modify a procedure which method is better; storing code of procedure in a sql file and at the time of appying a change modify the code and run that SQL file OR writing every time a method with code ALTER PROCEDURE?

    Amol


  2. #2
    Join Date
    Aug 2001
    Location
    Hyderabad, India
    Posts
    29
    User_Source
    Venkateshwarlu.K

  3. #3
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    select text from user_source where name='YOUR_PROCEDURE'
    Order by line
    /

    I will code in a SQL script (text file) and run the script in sqlplus. This way you have more control over changes and you can run it again after modifying code till you get the desired result.

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