ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Koka <226...@gmail.com>
Subject Re: Stored procedures returning resultset
Date Tue, 09 Aug 2005 14:54:57 GMT
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>

Mime
View raw message