aspose file tools*
The moose likes JDBC and the fly likes Is there a way to get the parameters for a stored PRocedure? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Is there a way to get the parameters for a stored PRocedure?" Watch "Is there a way to get the parameters for a stored PRocedure?" New topic
Author

Is there a way to get the parameters for a stored PRocedure?

Pablo Ganga
Greenhorn

Joined: Oct 12, 2005
Posts: 13
you know, I work in aspx and we use Aplication block Data, and I asked to myself if there any way to obtain the parameters for a stored procedure in jdbc.

in .net it would be like this:

//we get an array of parameters
IDaraParameter[] params = OracleHelper.getParametersSet("Nombre Procedimiento",OracleCOnection).

well i hope you can help me


MCAD<br />SCJP JAVA 5<br />SCWCD 1.4
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Originally posted by Pablo Ganga:
if there any way to obtain the parameters for a stored procedure in jdbc.


Of course you can do this in JDBC
  • Obtain the connection from DataBase
  • Call the getMetaData() on connection, you will get DatabaseMetaData
  • Use the getProcedureColumns() method to get the parameter names of your procedure




  • Shailesh


    Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
    Pablo Ganga
    Greenhorn

    Joined: Oct 12, 2005
    Posts: 13
    Thanks a lot for the help i'll do just that
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: Is there a way to get the parameters for a stored PRocedure?