Subject Re: [firebird-support] Firebird SP in Java
Author Martijn Tonies
Please don't send "high priority" email to an emailing list.

> For those who use java language.
> How can I make to use a STORED PROCEDURE with IN and OUT values?
> And in the SP what should I do?

Here's an example:
SET TERM ^^ ;
CREATE PROCEDURE P_2 (
I1 Integer,
I2 Integer)
returns (
O1 Integer,
O2 Integer,
O3 Integer)
AS
begin
o1 = 1;
o2 = 2;
o3 = i1 * 3;
end
^^
SET TERM ; ^^

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com