Re: desc stored procedure via query

try something like:
select substr(text,Instr(text,'IN ') -2 ,Instr(text,'IS ' -2)) from dba_source where name = 'procedureName'; ( assumes CAPS for IN and IS for first string after OUT paramslist ) You will probably need to experiment with restricting how far into the text it looks to find the IN by using substr(instr( substr(text,start,end),'IN'  

hth,

spamguard_at_orlandoartistry.com (Kevin Bridges) wrote:

>I need to run a query to retrieve the IN/OUT parameters of a procedure
>... basically the information that gets displayed in SQL*Plus when you
>desc procedurename.
>
>I can get the entire procedure by doing the following, but need just
>the desc info:
>select text from dba_source where name = 'procedureName';
>
>TIA
>
>Kevin Bridges

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Jul 26 2002 - 16:06:38 CDT