Thread: Stored proc returns RECORD & JDBC
Hi.
As you know we have to invoke the stored proc which returns RECORD in the following manner:
Select * from func() as (a datatype1, b datatype2…);
There is no problem to execute such statement as PreparedStatement.
But I need to use only CallableStatement.
Does anyone know how to do it?
Thanks.
Igor Borisovsky wrote:
> As you know we have to invoke the stored proc which returns RECORD in
> the following manner:
>
> Select * from func() as (a datatype1, b datatype2…);
>
> There is no problem to execute such statement as PreparedStatement.
>
> But I need to use only CallableStatement.
>
> Does anyone know how to do it?
That query will work fine directly in a CallableStatement -- it's a
superset of PreparedStatement.
If you meant "I need to use the {call} escape syntax in a
CallableStatement to generate a query like this" then you can't do that
with the current driver.
-O