Re: test script

I just gave you two.  You already have a stored procedure.  I sent examples
of PL function definition from SqlTool that return values to SqlTool.  You
can just change one of the function implementations to call your SP and
return the needed value.

On Sat, Nov 30, 2019 at 1:10 PM Jorge Garcia de Alba <
[email protected]> wrote:

> Brian,
>
> Is there an example script that exemplifies this situation?
>
> On 11/30/19, Blaine Simpson <[email protected]> wrote:
> > I would think that if you want to access a PL variable outside of the PL
> > itself, you would output it with a PL function.  You could make a wrapper
> > function for your procedure that returns the populated variable.  Use
> > "CALL" for the function as shown in test scripts
> > /testrun/sqltool/swqljrt.sql and /testrun/sqltool/sqlj.sql in your
> HyperSQL
> > distribution.
> >
> > Somebody else may know of a more direct way.
> >
> > On Sat, Nov 30, 2019 at 11:57 AM Jorge Garcia de Alba <
> > [email protected]> wrote:
> >
> >> Hello,
> >>
> >> What would a script that saves procedure out parameter value to
> >> variable (that can be run from sqltool) look like?
> >>
> >> java -jar $HSQLDB_HOME/lib/sqltool.jar urlid file.sql... > /tmp/file.log
> >> 2>&1
> >>
> >> Thanks,
> >>
> >> Jorge
> >>
> >
>
>
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>

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