Subject RE: [Firebird-Java]
Author Rotandiko Sastroprawiro

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

> How to call Stored Procedure ?

You can use InterBase syntax:

PreparedStatement ps = connection.prepareStatement(
"EXECUTE PROCEDURE my_proc(?,...?)");

ps.setXXX(..., ...);


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:

Your use of Yahoo! Groups is subject to