From ff3df488f5d84a1fa6288adaaa48948fe1614e7d Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 7 Oct 2008 16:58:53 +0000 Subject: - Oracle will detect string-based statements which contain comments at the front before a SELECT as SELECT statements. [ticket:1187] --- lib/sqlalchemy/databases/oracle.py | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'lib/sqlalchemy/databases') diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py index 3f5077d1a..eb02d4505 100644 --- a/lib/sqlalchemy/databases/oracle.py +++ b/lib/sqlalchemy/databases/oracle.py @@ -14,6 +14,8 @@ from sqlalchemy.sql import operators as sql_operators, functions as sql_function from sqlalchemy import types as sqltypes +SELECT_REGEXP = re.compile(r'(\s*/\*\+.*?\*/)?\s*SELECT', re.I | re.UNICODE) + class OracleNumeric(sqltypes.Numeric): def get_col_spec(self): if self.precision is None: @@ -206,6 +208,9 @@ class OracleExecutionContext(default.DefaultExecutionContext): self.out_parameters[name] = self.cursor.var(dbtype) self.parameters[0][name] = self.out_parameters[name] + def returns_rows_text(self, statement): + return SELECT_REGEXP.match(statement) + def create_cursor(self): c = self._connection.connection.cursor() if self.dialect.arraysize: -- cgit v1.2.1