Find the code for a Procedure currently in the oracle database
There is procedre in my database, PROCEDURE SYS.HANDLE_TBS_DDL. I want to see the script or the "code" that is currently residing in the database. Which table DBA_% or view V$_% can show me the code of this procedure. This procedure is there and is working as expected. I just want to see the code and see what calls it is making and where.
To be a little more specific:
select text from dba_source where owner='SYS' and name='HANDLE_TBS_DDL' order by line;
Also, you shouldn't create objects in the SYS schema.
select text from dba_source where owner='SYS' and name='HANDLE_TBS_DDL' order by line;
Also, you shouldn't create objects in the SYS schema.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if the procedure is part of a package, you'll need to look for the package name, not the procedure