This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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?
     
    Similar Threads
    After insert statement, how do I get column value populated by DB trigger
    How to call stored procedure from Entity Manager if there is out parameter in stored procedure.
    Oracle Java Stored Procedure ... Urgent help needed.
    conn.prepareCall
    sql server callable statement result set issue..