Short answer is no... You are on the server side create a package to open fetch from and close a dynamic ref cursor. on the client side set up environment and connect.. Allocate statement handles Prepare the open cursor Bind the values Execute the open call Define the select item Fetch the data
cheers, M "Repine, Burt" wrote: > > This might be more of an Oracle question but........ > We're making Oracle 8.1.7 stored proc calls from our Java source through > JDBC using an Oracle thin driver. > Is there a way to handle multiple records without having to call the stored > proc once for each record it's returning? > > Thanks for any input! > > To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm
