Hi Gurus,
I have a stored procedure which accepts boolean parameters as IN. In ado.net
the system.data.oracleclient does not have boolean data type when declaring
the parameter names.

Please advise what should be done and the possible workarounds.

I m in a tight position, and need a reply soon.
Many thanks,



--
Life is a box of chocolates. You never know what u get till you try it.

On Mon, 25 Jul 2005 23:14:01 -0700, JLo <(E-Mail Removed)> wrote:

¤ Hi Gurus,
¤ I have a stored procedure which accepts boolean parameters as IN. In ado.net
¤ the system.data.oracleclient does not have boolean data type when declaring
¤ the parameter names.
¤
¤ Please advise what should be done and the possible workarounds.
¤
¤ I m in a tight position, and need a reply soon.
¤ Many thanks,

A Boolean in Oracle is a PL/SQL specific data type. AFAIK there is no equivalent in the Microsoft
world.

You may want to use a VARCHAR2 or Number instead.


Paul
~~~~
Microsoft MVP (Visual Basic)

Hi Paul,
Even if I use Varchar2 or Number type in declaring the parameter, then what
do I pass to the parameter which expects a default Boolean value in the SP.

Also if I declare it as Varchar2 or Number in the parameters declaration in
..NET then do I need to make changes to the SP in Oracle PL/SQL.

Pls reply,
thanks


--
Life is a box of chocolates. You never know what u get till you try it.


"Paul Clement" wrote:

> On Mon, 25 Jul 2005 23:14:01 -0700, JLo <(E-Mail Removed)> wrote:
>
> ¤ Hi Gurus,
> ¤ I have a stored procedure which accepts boolean parameters as IN. In ado.net
> ¤ the system.data.oracleclient does not have boolean data type when declaring
> ¤ the parameter names.
> ¤
> ¤ Please advise what should be done and the possible workarounds.
> ¤
> ¤ I m in a tight position, and need a reply soon.
> ¤ Many thanks,
>
> A Boolean in Oracle is a PL/SQL specific data type. AFAIK there is no equivalent in the Microsoft
> world.
>
> You may want to use a VARCHAR2 or Number instead.
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
>