oracle boolean type [ticket:257]

1 files changed, 15 insertions, 1 deletions

diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py
index 897ed640e..6ca81c662 100644
--- a/lib/sqlalchemy/databases/oracle.py
+++ b/lib/sqlalchemy/databases/oracle.py
@@ -52,7 +52,21 @@ class OracleBinary(sqltypes.Binary):
         return "BLOB"
 class OracleBoolean(sqltypes.Boolean):
     def get_col_spec(self):
-        return "BOOLEAN"
+        return "SMALLINT"
+    def convert_result_value(self, value, dialect):
+        if value is None:
+            return None
+        return value and True or False
+    def convert_bind_param(self, value, dialect):
+        if value is True:
+            return 1
+        elif value is False:
+            return 0
+        elif value is None:
+            return None
+        else:
+            return value and True or False 	
+
         
 colspecs = {
     sqltypes.Integer : OracleInteger,