Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007

    Unanswered: Any dictionary view for SProc params, like ALL_TAB_COLUMNS gives info on tables cols?

    Hi guys

    I'd like to know if there is any metadata type view I can select from, that gives me info about the stored procedures a user has, what the parameters, types and direction are etc..

    Failing that, is the only way for this, going to be to use DBMS_METADATA to retrieve the DDL for the SProc and parse it?

    This is for a VB.NET app that will downlaod info about the proc and prompt the user for parameters but in a type safe fashion..

    thanks in advance

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    Sql> Desc Sp_name
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    Don't know if there's a view which meets your needs, but what I usually do to try and find out is submit a query like the following, and then investigate:

    select *
    from dictionary
    where table_name like '%PROC%' or table_name like '%ARG%'
    It turns out that there's an ALL_ARGUMENTS view that might work for you, if DESC doesn't.


Posting Permissions

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