Passing a PL/SQL boolean using OracleClient

[Ian Tompsett]

I'm using the OracleClient data provider to connect to an
8.1.7 database.

When trying to call a PL/SQL procedure with a boolean
parameter, I can't get any parameter types accepted. No
matter what type I use, I keep getting an ORA-06650 error
(wrong number of types or arguments).

My procedure definition can be as simple as:

procedure testProc (pDebug in boolean);

I've tried every possible combination, but just can't get
it to work. Any ideas on what I should be doing?

Thanks

 

[Miha Markic]

Hi Ian,

According to this thread you won't be able to use it,
http://groups.google.com/groups?hl=...e=UTF-8&oe=UTF-8&as_ugroup=*adonet*&lr=&hl=en
You might define the input parameter as number(1) instead and use 1/0.

 

[Ian Tompsett]

Thanks Miha

I checked out the post, and it seems to come down to the
problem of the boolean type supported by PL/SQL not being
a supported type for columns in the actual database.

So I'll just go with your number(1) suggestion.

Ian