Re: Temporary table in a procedure

You should build the latest SVN /base/trunk and test.

Fred

On Fri, Apr 3, 2015, at 12:14, Paul Slater wrote:
> Hello Fred,

>

> Sorry to be so long replying. Thank you for this. It is good to know
> that the engine is being developed. In the meantime Igot around it the
> Oracle way and declared a global temporary table.

>

> Many thanks, Paul

>

> From: Fred Toussi [mailto:[email protected]] Sent: Tuesday,
> 31 March 2015 3:17 AM To: User discussions about HyperSQL Database
> Engine. Subject: Re: [Hsqldb-user] FW: Temporary table in a procedure

>

> The DECLARE CURSOR feature did not support selecting from tables that
> are declared inside the procedure. The latest SVN code supports this
> feature. You can build the jar and use it until the final 2.3.3
> release (date as yet unknown)

>

> Fred

>

> On Sun, Mar 29, 2015, at 05:36, Paul Slater wrote:

>> 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

> ------------------------------------------------------------------------------
> 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

------------------------------------------------------------------------------
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