Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> how to get "Start_line" and "End_line" (in USER_SOURCE view) of each function and procedure in package body?
Hi,
For each db package , I can get a list of it's functions and procedures using the following query. But I want to know their "Start_line" and "End_line" (the LINE column value in USER_SOURCE view) of each function and procedure in the package body. How do I get that?
Thanks.
Guang
select object_name , 'FUNCTION' type from user_arguments
where PACKAGE_NAME= l_pkg_name
and position in (0)
and ARGUMENT_NAME IS NULL
UNION ALL
(
select object_name, 'PROCEDURE' type from user_arguments
where PACKAGE_NAME=l_pkg_name
and position in (1)
minus
select object_name, 'PROCEDURE' type from user_arguments
where PACKAGE_NAME=l_pkg_name
and position in (0)
);
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 13 2006 - 14:45:20 CST
![]() |
![]() |