Voici ses principaux champs :
| Nom du champ | Type du champ | Description du champ |
| owner | VarChar | Nom du propriétaire de la procédure ou de la fonction. |
| procedure_name | VarChar | Nom de la procédure ou de la fonction. |
SELECT
a.owner,
'',
DECODE(a.procedure_name,
NULL, '',
a.object_name),
DECODE(a.procedure_name,
NULL, a.object_name,
a.procedure_name),
upsora.isafunction(a.owner,
DECODE(a.procedure_name,
NULL, '',
a.object_name),
DECODE(a.procedure_name,
NULL, a.object_name,
a.procedure_name)),
upsora.procedure_nbparameters(
DECODE(a.procedure_name,
NULL, '',
a.object_name),
DECODE(a.procedure_name,
NULL, a.object_name,
a.procedure_name)),
c.comments
FROM ALL_PROCEDURES a, ALL_TAB_COMMENTS
WHERE
a.owner=c.owner(+)
AND DECODE(a.procedure_name, NULL, a.object_name, a.procedure_name)=c.table_name(+)
AND c.table_type='PROCEDURE'
AND a.object_name LIKE 'MonSchema%'
AND a.table_name LIKE 'MaProcedure%'
ORDER BY a.object_name, a.procedure_name;