View stored procedure source code

Subasish · #1 (**permalink**) 01-13-12, 03:21

Hi

What d query to see the source code of stored procedure contained inside a package in oracle?

Thanks and regards
Subasish

aflorin27 · #2 (**permalink**) 01-13-12, 03:43

SELECT Text
FROM SYS.DBA_SOURCE
WHERE TYPE = 'PACKAGE BODY'
AND OWNER = package_owner
AND NAME = package_name
ORDER BY LINE

Subasish · #3 (**permalink**) 01-13-12, 05:04

Thanks for the reply aflorin27, but I want to see the text of the Stored procedure defined inside a particular package. All info I have is, the stored procedure and package name.

Littlefoot · #4 (**permalink**) 01-13-12, 05:26

Did you try to run a query Florin posted? If you can't access DBA_SOURCE, you need to acquire privileges to do so. Or, if a package is located in a schema you have access to, you could use USER_SOURCE instead.

Because, it runs perfectly well.

Code:

SQL> SELECT Text
  2   FROM USER_SOURCE
  3   WHERE TYPE = 'PACKAGE BODY'
  4   AND NAME = 'PKG_DEGIS'
  5   ORDER BY LINE;

TEXT
----------------------------------------------
package body       pkg_degis as

  function f_dg_admin (par_user in char)
    return boolean
  is
<snip>

Internet Services

Web Development

Digital Marketing

Consumer Tech