Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    UK(berkshire)
    Posts
    11

    Unanswered: Parameter details for Stored Procedures

    Using the data dictionary or something else.

    I was wondering how I could get a list of parameters(name,type,etc) expected by a stored procedured ?

    Linked to http://dbforums.com/t911825.html
    Thanks

    youeee

  2. #2
    Join Date
    Aug 2003
    Posts
    41
    USER_ARGUMENTS data dictionary holds this info.

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Parameter details for Stored Procedures

    See ALL_ARGUMENTS. There is also a package called DBMS_DESCRIBE that may be helpful.

  4. #4
    Join Date
    Aug 2003
    Location
    UK(berkshire)
    Posts
    11

    Thanks

    Originally posted by sunilthomas98
    USER_ARGUMENTS data dictionary holds this info.
    Thanks

    This is great help
    Thanks

    youeee

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •