For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
how to update transient attribute when update dependencies attribute in view object such as salary and salary + 500 , when change salary transient attribute don't update .
Read the documentation: https://python-oracledb.readthedocs.io/en/latest/user_guide/connection_handling.html#connecting-to-oracle-cloud-autonomous-databases The default 'Thin' mode of python-oracledb you are using needs the wallet in PEM file format. This is a requirement of the Python libraries now being used, since Thin mode doesn't use the Oracle Client libraries (which use a .sso file). Recent wallet.zip files include a .pem file. If you don't have one, then re-download the wallet.zip file. Or you can convert the .p12 file in your wallet.zip to a .pem file using the utility script in the documentation. Pass the directory (not including the filename) containing the wallet when you connect. You also need to specify the wallet password: connection = oracledb.connect(user='northwind', password=pw, dsn='db21cpresent_medium', config_dir="c:\the\dir\containing\the\tnsnames\file", wallet_location=r"c:\the\dir\containing\the\pem\file", wallet_password=wpw, ) Alternatively, enable 'Thick' mode and you won't need the above. A third option is to use 1-way TLS. That is also in the documentation
Great thanks, Christopher! It works with the specification of the three parameters (Windows 10) now: connection = oracledb.connect(user='northwind', password=pw, dsn='db21cpresent_medium', config_dir="c:\\my\\wallet\\dir", wallet_location="c:\\my\\wallet\\dir", wallet_password=wpw ) In my wallet-dir there are the tnsname.ora and ewallet.pem files after unzipping of the wallet.zip file. Ciao, Friedhold
Thanks! Fixed the issue for me here!