How to find Lines of Code of packaged procedures and functions in Oracle

oracle package lines-of-code
Rajan picture Rajan · Jul 2, 2012 · Viewed 11.2k times · Source

Possible Duplicate:
How to View Oracle Stored Procedure using SQLPlus?

Im new to Oracle. Could you please help me on this?

How to fine Lines of Code of packaged procedures and functions in Oracle?

Is there any system tables or query to find the LOC of procedures and functions inside any package?

Answer

DCookie picture DCookie · Jul 2, 2012

Check out the ALL_SOURCE view in the Oracle dictionary.

Related questions

Can I recover older Oracle pl/sql source code from a package body after i have replaced with newer code

I had created an Oracle PL/SQL package with a header and a body with lots of code. Later, I ended up accidentally erasing the code from that body after reran the CREATE OR REPLACE PACKAGE BODY... statement with different …

Read More
Oracle User defined type inside package definition

is it possible to have a User Defined Type inside Oracle package definition? When I try following CREATE OR REPLACE PACKAGE AF_CONTRACT AS -- spec -- PROCEDURE my_rpcedure (emp_id NUMBER); TYPE DTO_GRID AS OBJECT ( ROWKEY NVARCHAR2(200), …

Read More
Unable to 'SELECT INTO' when value doesn't exist

SELECT Value1 INTO lValue FROM Table1 WHERE Field1 = lTempValue; This works fine when the match is true. But if the match isn't true, I receive an error. ORA-01403: no data found Ideally, that's fine with me because I'm going to …

Read More