Re: [sqlalchemy] Oracle wallets + proxy authentication with arguments encoded as strings in URL

"oracle://[proxy_to_user]@my_wallet" worked! Thanks again. On Thu, Nov 14, 2019 at 2:14 PM Mike Bayer wrote: > > > On Thu, Nov 14, 2019, at 2:52 PM, Chris Stephens wrote: > > I'm attempting to make use of an Oracle wallet with proxy authentication &

[sqlalchemy] Oracle wallets + proxy authentication with arguments encoded as strings in URL

I'm attempting to make use of an Oracle wallet with proxy authentication passed as strings in URL. The documentation states: "Changed in version 1.3: the cx_oracle dialect now accepts all argument names within the URL string itself, to be passed to the cx_Oracle DBAPI. As was the case earlier

Re: [sqlalchemy] Proper way to handle new 128 character identifier limit in Oracle >= 12.2

I think you would actually want to query v$parameter since "compatible" can be set to a lower version than server which disables 128 lengths. SQL> select value from v$parameter where name = 'compatible'; VALUE -- 12.2.0 On Thursday, November 8, 2018 at 10:30:19 AM UTC-6, Mike Bayer

[sqlalchemy] Oracle Bulk inserts returning array of IDs possible?

Is is possible to implement the following behavior in SQLAlchemy against an Oracle database? (Bulk inserts returning PK IDs generated by trigger/sequence on PK column in database) #database ddl DROP TABLE INS_RET_TEST; CREATE TABLE INS_RET_TEST (ID NUMBER NOT NULL ENABLE,