Hi Team,
I want to find all the stored procedure in my schema which are not having input parameters. I have tried below query but no luck.
SELECT * FROM USER_OBJECTS WHERE OBJECT_NAME NOT IN
(SELECT UNIQUE OBJECT_NAME
FROM ALL_ARGUMENTS A where A.owner='xxxxx'
AND OBJECT_NAME IN (SELECT UNIQUE OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE='PROCEDURE'))
AND OBJECT_TYPE='PROCEDURE'.
inner query I'm taking all the procedure having input parameters then I'm filtering the procedures not having input parameters.
unfortunately I'm getting the some procedures which are having input parameters. when I queried the same objects from the ALL_ARGUMENTS table it is not giving me any record.
could you please let me know why those objects are not exists in ALL_ARGUMENTS.
Many Thanks,
Harikanth.