I asked on the SQLAlchemy group how to execute SQL statements at
application initialisation (to make the Oracle session case
insensitive).

I was given a snippet which involves adding listeners to the
SQLAlchemy create_engine call:

class MySetup:
    def connect(self, dbapi_con, con_record):
        dbapi_con.execute('alter session set NLS_SORT=BINARY_CI')
        dbapi_con.execute('alter session set NLS_COMP=LINGUISTIC')

engine = create_engine('oracle:...', listeners=[MySetup()])

How can I accomplish this when using Elixir?

Thanks for your help,

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

Reply via email to