Re: Help! IN BOOLEAN in Call procedure failed

Hi,
Thank's!
But actually, i can't call this procedure! How i can initialize ? With Set(Type)?
Have you a suggestion ?
I'm not owner of this procedure and i can't change it !

Sybrand Bakker <postbus_at_sybrandb.demon.nl> a écrit dans le message : 954233102.7978.1.pluto.d4ee154e_at_news.demon.nl...
> No,
>
> Boolean is an internal PL/SQL datatype ONLY.
>
> Sorry,
>
> Sybrand Bakker, Oracle DBA
>
> 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 - 11:32:56 CEST