Re: How to pass a boolean to a stored proc using Cx_Oracle?

Discussion in 'Python' started by Gabriel Genellina, Nov 25, 2006.

  1. At Wednesday 22/11/2006 15:37, JG wrote:

    >I am using Python 2.4 and cx_Oracle. I have a stored proc that takes two
    >arguments. First is an NUMBER, second is a BOOLEAN. How do you call that
    >stored procedure?
    >
    >After properly extablishing a connection, I have something like this:
    >
    >cursor = con.cursor()
    >cursor.callproc("testproc",[123,True])
    >
    >The problem I have ran into is that I keep getting an error from Oracle
    >stating I don't have the variables defined in with the proper type. I
    >changed to proc just to test it, so that it would take two numbers. I was
    >able to make it run properly.
    >
    >So, what is the trick to pass a boolean?


    I've never used cx_Oracle, but have you tried using 0/1 as False/True?


    --
    Gabriel Genellina
    Softlab SRL

    __________________________________________________
    Correo Yahoo!
    Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
    ¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
     
    Gabriel Genellina, Nov 25, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. David Lozzi
    Replies:
    3
    Views:
    1,941
    David Lozzi
    Jun 1, 2005
  2. JG
    Replies:
    0
    Views:
    300
  3. Replies:
    1
    Views:
    459
  4. Cirene

    How pass null to stored proc

    Cirene, May 26, 2008, in forum: ASP .Net
    Replies:
    3
    Views:
    370
    Mark Fitzpatrick
    May 27, 2008
  5. Jason  Vogel
    Replies:
    0
    Views:
    94
    Jason Vogel
    Nov 28, 2006
Loading...

Share This Page