Viewing Stored Procedures

[HavaTheJut]

How do I view a packaged stored procedure in order to see the source code? A simple select statement didn't work (as I expected). Is there any way to view the code from the console, or do I have to use other means?
Thanks.

 

[carp]

SELECT text
FROM dba_source
WHERE name = 'MY_PROCEDURE_NAME'
AND type = 'MY_PROCEDURE_TYPE'
ORDER BY line;

 

[HavaTheJut]

Thank you carp. I can get to the procedures that are not packaged, but how do I view those inside of a package?

 

[jimbopalmer]

SELECT text
FROM all_source
WHERE name = 'MY_PROCEDURE_NAME'
AND type = 'MY_PROCEDURE_TYPE' /* is PACKAGE BODY in your case */
ORDER BY line; I tried to remain child-like, all I acheived was childish.

 

[carp]

Right - something like
SELECT text
FROM dba_source -- or all_source or user_source
WHERE name = 'DBMS_RANDOM'
AND type = 'PACKAGE BODY';

 

[sem]

Don't forget about ORDER BY LINE. It's quite unusual, but Oracle MAY return rows in wrong order without this clause.