Oracle , parameters of procedures of an Owner

Asked

Viewed 96 times

1

On Oracle which table or view of metadata I have the parameters of a Procedure.

My question is , that procedures HAS parameters with the name similar to "XPTO" ?

I tried for the "Dict" but I couldn’t find.

sql oracle pl-sql oracle11g

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'

  • Right on the money !! Perfect "Arguments" I was looking for "Parameters"

Browser other questions tagged sql oracle pl-sql oracle11g

You are not signed in. Login or sign up in order to post.