fixed OracleRaw type adaptation [ticket:902]

2 files changed, 5 insertions, 3 deletions

diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py
index edc8a7d3f..5ce94a992 100644
--- a/lib/sqlalchemy/databases/oracle.py
+++ b/lib/sqlalchemy/databases/oracle.py
@@ -107,9 +107,6 @@ class OracleText(sqltypes.Text):
                     return value
         return process
 
-class OracleRaw(sqltypes.Binary):
-    def get_col_spec(self):
-        return "RAW(%(length)s)" % {'length' : self.length}
 
 class OracleChar(sqltypes.CHAR):
     def get_col_spec(self):
@@ -134,6 +131,10 @@ class OracleBinary(sqltypes.Binary):
                 return value
         return process
 
+class OracleRaw(OracleBinary):
+    def get_col_spec(self):
+        return "RAW(%(length)s)" % {'length' : self.length}
+
 class OracleBoolean(sqltypes.Boolean):
     def get_col_spec(self):
         return "SMALLINT"
diff --git a/test/sql/testtypes.py b/test/sql/testtypes.py
index 0c10247e5..09a3702ee 100644
--- a/test/sql/testtypes.py
+++ b/test/sql/testtypes.py
@@ -83,6 +83,7 @@ class AdaptTest(TestBase):
             (oracle_dialect, Unicode(), oracle.OracleText),
             (oracle_dialect, UnicodeText(), oracle.OracleText),
             (oracle_dialect, NCHAR(), oracle.OracleString),
+            (oracle_dialect, oracle.OracleRaw(50), oracle.OracleRaw),
             (mysql_dialect, String(), mysql.MSText),
             (mysql_dialect, VARCHAR(), mysql.MSString),
             (mysql_dialect, String(50), mysql.MSString),