The moose likes JDBC and Relational Databases and the fly likes Oracle stored procedure result set ref problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle stored procedure result set ref problem" Watch "Oracle stored procedure result set ref problem" New topic
Author

Oracle stored procedure result set ref problem

Ali Gohar
Ranch Hand

Joined: Mar 18, 2004
Posts: 572
Hi,

I am calling an oracle stored procedure through JDBC in a java application. This stored procedure returns a resultset as an out parameter, while getting the resultset parameter, jdbc is taking too much time about 5 to 6 mins. Here is the sample code i am using:



Can anybody help??

Thanks
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
What are you dealing with then within the Stored Procedure call?
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Oracle stored procedure result set ref problem
 
It's not a secret anymore!