By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,630 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,630 IT Pros & Developers. It's quick & easy.

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

P: n/a
JG
Hi,
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?

Thanks,
joe

Nov 22 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.