Re: Help! IN BOOLEAN in Call procedure failed

I had the same type of problem with returning a boolean FROM an Oracle stored procedure. I ended up using the CHAR values 'T' and 'F' instead.

Shannon Hickey
shickey_at_frameworks.ca

"Titou" <t.merlin_at_free.fr> wrote in message news:KUZD4.63$Y4.123001_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 generated :
> ORA-06550
> PLS-00306
> I'm sure than this problem come with boolean because when i replace by
> String
> in my procedure and java code, it's OK!
> Can you help me on this type boolean?
> Thank's in advance.
>
>
>
Received on Tue Mar 28 2000 - 21:02:14 CEST