How to call a Stored Procedure in Oracle having Boolean IN paramet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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