From cd8a3390e6992a1a969af47ee6268456d7890aa8 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Wed, 3 Sep 2008 18:16:55 +0000
Subject: [PATCH]  added BFILE to reflected type names [ticket:1121]

---
 CHANGES                            | 1 +
 lib/sqlalchemy/databases/oracle.py | 1 +
 2 files changed, 2 insertions(+)

diff --git a/CHANGES b/CHANGES
index 410f8647d5..1f7151823e 100644
--- a/CHANGES
+++ b/CHANGES
@@ -144,6 +144,7 @@ CHANGES
       in conjunction with DISTINCT. [ticket:536]
     - has_sequence() now takes the current "schema" argument into
       account [ticket:1155]
+    - added BFILE to reflected type names [ticket:1121]
 
 0.5beta3
 ========
diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py
index 4ab27152ef..3f5077d1ae 100644
--- a/lib/sqlalchemy/databases/oracle.py
+++ b/lib/sqlalchemy/databases/oracle.py
@@ -180,6 +180,7 @@ ischema_names = {
     'DATETIME' : OracleDateTime,
     'NUMBER' : OracleNumeric,
     'BLOB' : OracleBinary,
+    'BFILE' : OracleBinary,
     'CLOB' : OracleText,
     'TIMESTAMP' : OracleTimestamp,
     'RAW' : OracleRaw,
-- 
2.47.3