Hi,
Unfortunately, H2 does not support the syntax SELECT * FROM
TABLE(GET_NUMBERS()).
Regards,
Thomas
On Friday, April 27, 2012, Łukasz Drumiński wrote:
> Loic, thanks for answer. My situation is that: I use on production Oracle
> database. Now, I'm trying to use H2 in integration tests. In
Loic, thanks for answer. My situation is that: I use on production Oracle
database. Now, I'm trying to use H2 in integration tests. In application on
production I use exacly this query: SELECT * FROM TABLE(GET_NUMBERS()) and
its not good idea to change it. So I'am asking, is there any way to handle
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
