Hi,
You could do the following prepared statement :
SELECT * FROM TABLE(ID NUMBER=?)
then you can set the parameter with a setObject(1,new Object[]
{1,2,3,4,5,6,7,8,9,10})
If you really want to do an external java function (though I do not
understand why), I suppose you could write
SELECT * FROM TABLE(ID NUMBER=GET_NUMBERS())
...and the function must return an array. But I'm not sure if it is
possible to do that.
LP
2012/4/27 Łukasz Drumiński <[email protected]>
> Hello,
>
> this is working fine:
>
> SELECT * FROM TABLE(ID NUMBER=(1, 2, 3, 4, 5, 6, 7, 8, 9, 10))
>
> but I need to do something like this:
>
> SELECT * FROM TABLE(GET_NUMBERS())
>
> is this posible?
>
> I could create alias GET_NUMBERS for some Java method but I don't know
> how this method should look. I will be grateful for any help.
>
> Regards,
> Lukas
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
