Thread: Stored proc returns RECORD & JDBC

Stored proc returns RECORD & JDBC

From
"Igor Borisovsky"
Date:

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.

 

Re: Stored proc returns RECORD & JDBC

From
Oliver Jowett
Date:
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