Developer

Dynamic Paging, Calling Oracle XML From Java

Last week I wrote about how to dynamically get paged results from a stored procedure using either a ref cursor or an XML document. Rakesh wrote and asked to see an example of a call using Java. So that's what I wrote.I think the code is pretty much self-explanatory. I used jDeveloper to compile this. It's a console app that connects to the HR account of an Oracle XE database and returns some employee last names. Read the rest of this article.

Editor's Picks