Acessing ALL_SOURCE in a Procedure
Hi,
I'm trying to access all my source code developed for many users (schemas).
I wrote the following query:
SELECT TRIM(NAME) NAME, TRIM(TYPE) TYPE
FROM ALL_SOURCE
WHERE TYPE IN ('PACKAGE', 'PACKAGE BODY', 'FUNCTION', 'PROCEDURE', 'TYPE', 'TYPE BODY','TRIGGER')
AND OWNER = 'OWNER'
AND LINE = 1
When I'm executing on any client (SQLPLUS, PLSQLDEVELOPER etc), the result is correctly showed. When I execute the procedure with the same query, the result shows no lines.
What I'm doing wrong?
OD
Edited by: user4469789 on 14/01/2009 09:09