Problem with Call procedure Jdbc THIN

From: Titou <t.merlin_at_free.fr>
Date: Fri, 24 Mar 2000 11:57:31 GMT
Message-ID: <LKIC4.1855$9p6.6131834_at_nnrp4.proxad.net>

Hi,
I have a problem when i call a procedure with an boolean type. My procedure :

create or replace procedure TEST is (data1 IN BOOLEAN, data2 IN VARCHAR2,data4 OUT VARCHAR2) is
begin

    data4 := 'TEST';
end;

My java code :

            proc = conn.prepareCall("{call TEST(?,?,?)}");
            proc.setBoolean(1,true);
            proc.setString(2,"TEST");
            proc.registerOutParameter(3,java.sql.Types.VARCHAR);
            proc.execute();

This error code is generate :
ORA-06550
PLS-00306
I'm sure than this problem come with boolean because when i replace by Sting in my procedure and java code, it's OK!
Can you help me on this type boolean?
Thank's in advance. Received on Fri Mar 24 2000 - 12:57:31 CET