Subject | Re: [Firebird-Java] |
---|---|
Author | rrokytskyy |
Post date | 2002-06-18T15:30:19Z |
> How to call Stored Procedure ?You can use InterBase syntax:
PreparedStatement ps = connection.prepareStatement(
"EXECUTE PROCEDURE my_proc(?,...?)");
ps.setXXX(..., ...);
...
ps.executeUpdate();
or
PreparedStatement ps = connection.prepareStatement(
"SELECT * FROM my_proc(?, ...?)");
when your procedure returns you results. We do not fully support
escaped syntax for stored procedures yet (and probably will not in
the nearest future).
However, if your procedure takes only input parameters, you can use
standard JDBC escaped syntax:
{call my_proc(?, ..., ?)}
Best regards,
Roman Rokytskyy