how I ca have the name of parameters of an stored procedure?

[Guest]

Hi,

I have an stored procedure with a lot of parameters. I want to list them automatically by writing codes to show me the name of all parameters

thanks,

mandana

[Dan_Bracuk]

Read Adam Cameron's answer to the other thread you started.

[Guest]

That one works for table not stored procedure.

[Adam Cameron.]

<cfdbinfo> can't help you here.  I've lobbied to get it enhanced so that it returns actual useful info regarding procs, but it fell on deaf ears.  I suspect because it would involve more work than simply putting a CF wrapper around the underlying JDBC DatabaseMetaData class, which is all <cfdbinfo> really does, as it stands now.

There are some issues raised to improve <cfdbinfo> (listed below).  It would be helpful if you voted for them.

http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=75686

http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=75684

Back to your original question... it's a bit hard to answer this without you saying what DB system you're using, as the answer will be different depending on the system.

--

Adam

[Adam Cameron.]

Back to your original question... it's a bit hard to answer this without you saying what DB system you're using, as the answer will be different depending on the system.

Actually one can do it with JDBC easily enough, so the solution would be DB-independent.

Have a look at this: http://java.sun.com/javase/6/docs/api/java/sql/DatabaseMetaData.html, specifically http://java.sun.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getProcedures(java.lang.String,%20java.lang.String,%20java.lang.String) and http://java.sun.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getProcedureColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String).

I did have some proof-of-concept code for this at some stage, but I cannae find it now, sorry.

--

Adam

[Guest]

I will see the links you sent me.

Thanks,

Mandana