Re: test script
Jorge Garcia de Alba <[email protected]> Sat, 30 Nov 2019 12:09:47 -0600
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <CAEVgvV9os61Fmcn0gqAasxEdaTpr3Upv=ByH0t7A8qL_PiaZjg@mail.gmail.com> |
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 >> >