FW: Temporary table in a procedure

Hello,

 

I want to declare a table in a procedure, populate it, manipulate the data
and return a result set. Unfortunately I can’t get even the most basic
attempt to compile. Please can someone help me with this….

 

create procedure sp_Balances(IN argAccount varchar(32))

modifies sql data dynamic result sets 1

begin atomic

declare table tbal(tnum integer,tdate date,trow integer);

declare resout cursor for select * from tbal for read only;     ç Fails
saying tbal doesn’t exist ??

/* Get raw data */

insert into tbal(select TxnNum,TxnDate,RowNum() from XL order by
TxnDate,TxnNum);

/* Manipulate data and send it back */

open resout;

end

 

Many Thanks, Paul

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user