On Mon, Apr 14, 2008 at 12:40 AM, Martijn Pieters <[EMAIL PROTECTED]> wrote:
>  I'll file one once I found a workable solution, if you like.

I found http://www.sqlalchemy.org/trac/ticket/994 and commented. It's
not as easy as just specifying bindparam_string unfortunately.

I added:

    def bindparam_string(self, name):
        # Oracle needs reserved words in parameters to be quoted
        if self.preparer._requires_quotes(name):
            name = self.preparer.quote_identifier(name)
        return super(OracleCompiler, self).bindparam_string(name)

and instead of ORA-01745: invalid host/bind variable name I now get
ORA-01036: illegal variable name/number.

The workaround for me is to use a different local key (Column(...
key='newkey-notreserved')).

-- 
Martijn Pieters

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to