Subject Re: [Firebird-Java] Re: How to call Stored procedure?
Author Rick Fincher
Hi Roman,

Can you post the corrected version? I'd like to put that in the FAQ.

Thanks!

Rick

----- Original Message -----

> > So should I rewrite the SP as selectable? Any other ideas?
>
> Can you check client-
> java/src/test/org/firebirdsql/jdbc/TestFBCallableStatement.java ?
>
> I just changed it a little bit and on my computer I'm able to
>
> a) use CallableStatement with {call ...} syntax;
> b) use PreparedStatement with SELECT * FROM ... (I had to add SUSPEND
> to it, you are right, my first example was wrong.)
>
> Best regards,
> Roman Rokytskyy