SELECT DISTINCT UPPER(NAME)
FROM ALL_SOURCE
WHERE TYPE = 'PROCEDURE'
AND OWNER = 'owner'
AND LOWER(TEXT) LIKE '%DBLINKNAME%'
ORDER BY UPPER(NAME)
FROM ALL_SOURCE
WHERE TYPE = 'PROCEDURE'
AND OWNER = 'owner'
AND LOWER(TEXT) LIKE '%DBLINKNAME%'
ORDER BY UPPER(NAME)