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?
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.
Click Here to Expand Forum to Full Width