how to access Oracle sql Mappings from code

[Bhaarat Sharma <bh...@gmail.com>]

I wont bother you guys by yet another oracle sql mapping question...

my question is simple. We are converting our iBatis mappings from sql server
compliant to oracle compliant.  We only use stored procedures...So since we
are moving to Oracle..every result set returned from a procedure will now
come back as a cursor.

In our code, previously we were doing:

List resultList =
getSqlMapClientTemplate().queryForList("mapping.mappingName", paramMap);

above particular call would put 13 different lists inside resultList.
 Meaning that the procedure returned 13 result sets.

Now with Oracle we will have:
getSqlMapClientTemplate().queryForObject("mapping. mappingName", paramMap);

Now paramMap (HashMap) will contain 13 entries. meaning 13 cursors.

I just want to know whether this is the best and most efficient way to do
this?

We want least bit of change to our code. So I'd appreciate any suggestions.

Thanks