I wasn't reading much in this thread, so I might have missed another suggestion. Sorry if that's the case.
However, I would just write a function that returns the result set. Then rather than executing the procedure and trying to get the results, Just run a regular query like "select * from getResults()" If getResults returns a table, then the result of the query will be that same result set. -----Original Message----- From: Koka [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 10:47 AM To: [email protected] Subject: Re: Executing a Stored Procedure returning rows from a Temporary table > I have a Stored Procedure which uses the input parameters passed to > it and returns rows from a temporary table which it creates I'd avoid changing iBatis code. Instead I'd go for a workaround like executing procedure that fills the table (but does not return rows) and next (in the same transaction of course) just run ordinary select statement on tha table. Just one extra statement sounds to me far better than changing iBastis code Koka
