Subject RE: [Firebird-Java]
Author Rotandiko Sastroprawiro
Thanks

-----Original Message-----
From: rrokytskyy [mailto:rrokytskyy@...]
Sent: Tuesday, June 18, 2002 11:30 PM
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java]


> 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



To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/