Get procedure parameters
1 posts in topic
Flat View  Flat View

Posted By:   Nhi_Nguyen
Posted On:   Friday, May 23, 2003 01:39 AM

Hi all,
I used oracle.jdbc.driver.OracleDriver for connection. I did the code below to get procedure's parameters but it did not work:

DatabaseMetaData DBSchema = m_Connection.getMetaData();
ResultSet TSchema = DBSchema.getProcedureColumns("", DBSchema.getUserName(), procedurename, null);

The ResultSet TSchema.next() always returns null
What I missed in this code ( catalogname? - maybe )
Help me, please
Thank you

Re: Get procedure parameters

Posted By:   Christopher_Schultz  
Posted On:   Friday, May 23, 2003 11:50 AM

I think your column_name parameter should not be null. Try passing '%' as the pattern instead.

Hope that helps,

About | Sitemap | Contact