[cx-oracle-users] How do you pass a boolean to a stored proc using cx_Oracle?
Brought to you by:
atuining
From: JG <z28...@gm...> - 2006-11-22 18:50:55
|
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 |