Get procedure parameters
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

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

Report | Quote This | Send private message | Reply | Print

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,

-chris
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact