Oracle, parameters of an Owner's procedures

Navigation
1

In Oracle what table or view of the metadata I have in the parameters of a Procedure.

My question is, does procedures have parameters with the name resembling "XPTO"?

I tried the "dict" but did not find it.

    
asked by anonymous 04.10.2017 / 18:09

1 answer

3

You could do it like this: 

SELECT OBJECT_NAME FROM ALL_OBJECTS A
  LEFT JOIN ALL_ARGUMENTS B
   ON A.OBJECT_ID = B.OBJECT_ID
  WHERE OBJECT_TYPE IN ('PROCEDURE') AND 
    B.ARGUMENT_NAME = 'XPTO'
    
04.10.2017 / 18:29
Amounts broken in installments, how to enter in the first to the third decimal place? Print on the dynamic list screen