Re: test script

Blaine,

I found:
hsqldb-2.5.0/hsqldb/testrun/sqltool/sqljrt.sql
hsqldb-2.5.0/hsqldb/testrun/sqltool/sqlpsm.sql

I will write a quick test. Thanks.

jr


On 11/30/19, Blaine Simpson <[email protected]> wrote:
> 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
>>
>