Subject | Re: [firebird-support] Firebird SP in Java |
---|---|
Author | Martijn Tonies |
Post date | 2004-07-07T11:15:01Z |
Please don't send "high priority" email to an emailing list.
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
> For those who use java language.Here's an example:
> How can I make to use a STORED PROCEDURE with IN and OUT values?
> And in the SP what should I do?
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