File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Pablo Ganga
Greenhorn
Posts: 13
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
     
    Pablo Ganga
    Greenhorn
    Posts: 13
    • 0
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Thanks a lot for the help i'll do just that
     
    I agree. Here's the link: http://aspose.com/file-tools
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic