hi, use ResultMap for that... Puneet Arya..
----- Original Message ---- From: "Nikesh, Kishlay" <[EMAIL PROTECTED]> To: "user-java@ibatis.apache.org" <user-java@ibatis.apache.org>; Java Discussion <[EMAIL PROTECTED]> Sent: Friday, 5 January, 2007 3:39:28 PM Subject: Returning multiple resultsets from Oracle 10g Hello, If we don't want to use stored procedures, is anyone aware of any way through which multiple resultsets could be returned in JDBC statements with Oracle 10g as database? Thanks in advance, Nikesh Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php