For sql server - "select * from information_schema.routines" might be
helpful.

>From: S. Isaac Dealey <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: OT: stored procedures meta data
>Date: Thu, 22 Jan 2004 11:50:42 -0600
>
>I'm wondering if anyone on the list knows if there's a way to get
>information about the parameters for a stored procedure (name,
>datatype and most importantly order) in a query from either Oracle or
>SQL Server (or both).
>
>
>s. isaac dealey                214-823-9345
>
>team macromedia volunteer      http://www.macromedia.com/go/team
>
>chief architect, tapestry cms  http://products.turnkey.to
>
>onTap is open source           http://www.turnkey.to/ontap
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to