Re: [Hsqldb-user] HSQLDB Procedures, SqlTool PL Scripts, and Test Scripts

[Fred T. <fr...@us...>]

This is the appropriate place.

You should be able to use a Java function called from an SQL procedure
to achieve this.

Fred

On Wed, 11 Aug 2010 09:00 -0700, "Tmo_hsqldb_q" <tm...@bg...>
wrote:
> 
> Recently I was bestowed with the following task.
> Create a procedure with parameters int count and int sleep that prints
> the
> count to screen and sleeps for the specified time.
> Call the procedure in a loop from two SQLTool sessions.
> 
> 
> In trying to achieve the task while working with HSQLDB Procedures,
> SqlTool
> PL Scripts, and Test Scripts, I noticed the following.
> 
> Procedures don't print to screen, or have a sleep function, but contains
> a
> working while loop with working math functions 
> ie: SET counter = counter + 1;
> PL Scripts do print to screen but don't have math or sleep functions
> Test Scripts do have a sleep function(ie /*w 5000*/) but don't have a
> print
> function.
> 
> 
> It would be nice to have a central location where all the functions
> exists. 
> If Procedures could be modified to have a Print 
> and a Sleep function.
> 
> 
> 
> Is this the appropriate medium to post something like this, or is there
> another place I can go. (ie Jira)
> 
> 
> thanks,
> Tony
> -- 
> View this message in context:
> http://old.nabble.com/HSQLDB-Procedures%2C-SqlTool-PL-Scripts%2C-and-Test-Scripts-tp29409851p29409851.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
> 
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by 
> 
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev 
> _______________________________________________
> Hsqldb-user mailing list
> Hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>