Re: Stored procedures returning resultset

[Koka]

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>