Re: test script
Blaine Simpson <[email protected]> Sat, 30 Nov 2019 12:23:14 -0500
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <CALbAep1VHkK4KzuWo67qKXJKAD6w-SPRKSVP01_w3Ov9AEhqSw@mail.gmail.com> |
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