The issue is, we have to use <procedure> calls as a company policy and not make <select> calls and hence I wanted to create the resultMap from the procedure call.
-----Original Message----- From: Koka [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 10:55 AM To: user-java@ibatis.apache.org Subject: Re: Stored procedures returning resultset No. You'll need to run extra select statement after executing the procedure to retrieve data from temporary table: Say your proc creates CREATE GLOBAL TEMPORARY TABLE temp_emp_table ( EMP_ID NUMBER, FNAME VARCHAR2(30), LNAME VARCHAR2(30), ) ON COMMIT DELETE ROWS; Then you need <statement id='getEmps' resultMAp='proc-result'> select * from temp_emp_table </statement>
