Xref: alice comp.databases.oracle.server:63294 comp.databases.oracle.tools:30852 Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!newsfeed.direct.ca!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail From: kimmel888@my-deja.com Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools,comp.lang.java.databases Subject: Java stored procedures questions Date: Wed, 25 Aug 1999 22:28:10 GMT Organization: Deja.com - Share what you know. Learn what you don't. Lines: 17 Message-ID: <7q1qlb$i46$1@nnrp1.deja.com> References: <7psih7$2vc$1@birch.prod.itd.earthlink.net> <37c9e6b7.110590570@newshost.us.oracle.com> X-Article-Creation-Date: Wed Aug 25 20:36:32 1999 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) X-Http-Proxy: 1.0 x30.deja.com:80 (Squid/1.1.22) for client 161.221.10.36 This question is regarding passing back an object other than a cursor. Is it possible to pass back a Array of some type to a java program? What actually needs to be done, is retrieve multiple pieces of data from multiple tables which are then added together to return a result set of dynamic size. So if I were to request the number (10) in my procedure, I would return an array of 10 values, which I can then parse through on the client side. Can this be done? If anyone has any information on this I would greatly appreciate it! Thankyou Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.