Passing a PL/SQL boolean using OracleClient

  • Thread starter Thread starter Ian Tompsett
  • Start date Start date
I

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
 
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
 
Back
Top