Java, Sybase and CallableStatement

Hi everybody,

I've got a problem in calling a stored procedure with a
CallableStatement in JAVA.

So I've got a stocked procedure on a Sybase database. Here is the code:

create proc ps_part_composite_firme
(@CodFirme varchar(50) = 'F12', @IdLangue int = 2)
as
begin
if (@IdLangue = 1)
begin
SELECT COD_COMP AS CODE_COMPOSITE, LIB_COMP AS LIB_COMPOSITE,
convert(char(8), DAT_OUV, 112) AS DATE_OUV,
convert(char(8), DAT_CLO, 112) AS DATE_CLO
FROM E_COMPOSITE
WHERE COD_FIRM = @CodFirme
ORDER BY LIB_COMP
end
else
begin
SELECT COD_COMP AS CODE_COMPOSITE, LIB_REPORT AS LIB_COMPOSITE,
convert(char(8), DAT_OUV, 112) AS DATE_OUV,
convert(char(8), DAT_CLO, 112) AS DATE_CLO
FROM E_COMPOSITE
WHERE COD_FIRM = @CodFirme
ORDER BY LIB_REPORT
end
end
go

--

Here are some lines of my Java method to call the stocked procedure:

String query = "{call ps_part_composite_firme [(?, ?)]}";
SybCallableStatement call =
(SybCallableStatement)this.conn.prepareCall(query);
call.setString(1,"F11");
call.setInt(2,1);
SybCursorResultSet syb_rs = (SybCursorResultSet)call.executeQuery();

[the connection on the database has been done above, works just fine (I
tryed some basic queries) and is not displayed here]

When executing the code, I have this error : There is no host variable
corresponding to the one specified by the PARAM datastream. This means
that this variable '' was not used in the preceding DECLARE CURSOR or
SQL command.

It seems the error is situated in the call.setString and/or call.setInt
instruction.
So I changed it for:

call.setString("CodFirme","F11");
call.setInt("IdLangue",1);

But now I've the error: There is no host variable corresponding to the
one specified by the PARAM datastream. This means that this variable
'CodFirme' was not used in the preceding DECLARE CURSOR or SQL command.

Does anyone have an idea?
Thanks!
Edouard Brière

.