DBD::Oracle doesn't recognize BOOLEAN.  Your best bet is to convert it to
VARCHAR2 in the wrapper you use to call the procedure.

For example (untested):
   DECLARE
     v_boolean BOOLEAN;
   BEGIN
      package.procedure( v_boolean );
      IF v_boolean THEN :bind := 'T';
      ELSE              :bind := 'F';
      END IF;
   END;

--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
----- Original Message -----
From: "Ravishankar Narasimhan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 22, 2001 22:02
Subject: ora_type


> I have a Stored Procedure that has a BOOLEAN IN/OUT
> Type. What ora_type should I be using for BINDING.



  • ora_type Ravishankar Narasimhan
    • Michael A Chase

Reply via email to